LIKE « Select Query « SQL Server / T-SQL






  1. SQL Server / T-SQL
  2. Select Query
  3. LIKE
1.Wildcard characters recognized by SQL Server for use in regular expressions.
2.LIKE operator with NOT
3.Use like to filter strings
4.LIKE '%[k-l]%'
5.LIKE 'A_____'
6.LIKE '^A%' (begining with A)
7.Like with variable
8.Like statement with two variables
9.Like with variable and wild card character




10.Like with escape