Wildcard characters recognized by SQL Server for use in regular expressions. : LIKE « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. LIKE

Wildcard characters recognized by SQL Server for use in regular expressions.

 


Wildcard    Searches for

%           Any string of zero or more characters.

_           Any single character.

[ ]         Any single character within the specified range (for example, [a-f]) or the specified set (for example, [abcdef]).

[^]         Any single character not within the specified range (for example, [^a-f]) or the specified set (for example, [^abcdef]).








Related examples in the same category

1.LIKE operator with NOT
2.Use like to filter strings
3.LIKE '%[k-l]%'
4.LIKE 'A_____'
5.LIKE '^A%' (begining with A)
6.Like with variable
7.Like statement with two variables
8.Like with variable and wild card character
9.Like with escape