August 14, 2013

SQL Wildcard Characters

In SQL, wildcard characters are used with the SQL LIKE operator.
SQL wildcards are used to search for data within a table. 
With SQL, the wildcards are:

Wildcard

%, -->A substitute for zero or more characters
_, --->A substitute for a single character
[charlist], -->Sets and ranges of characters to match
[^charlistor [!charlist], -->Matches only a character NOT 
specified within the brackets

No comments:

Post a Comment