SQL Wildcards
SQL Wildcards
SQL has a few wildcard characters. They are mostly used within the LIKE syntax however they can also be used in other conditional statements. There are several different ways to use wildcards but the result is that the DBA can use a partial text string to find a specific entry within the database. The following are the examples of the different wildcards and how they are used.
| Wildcard | Description |
| % | Returns all values that could be held by this place holder |
| _ | Allows exactly one character to be wild |
| [charlist] | Any character in the provided list |
| [^charlist] or [!charlist] | Any character not in the list |
