Subscribe to our YouTube Channel for more Videos

Wildcard Search in SQL Query


There are times when you don’t have a specific value to find but you might have to use the general pattern and want to get the records that match that pattern.

You can use the LIKE clause in this case and use the the wildcards for the search expression.

You can use the wild characters like % , _ , [..] , [^..] where % represents the string with zero or more characters. The _ represents the single character. The [] can be used to specify the list of characters like [A-Z]. [^..] represents the single character from the list that is present.

For example , you want to get the TOP 1000 department records whose name starts with E. Your query will look like the one below.

/****** Script for SelectTopNRows command from SSMS  ******/
SELECT TOP 1000 DepartmentID
      ,Name
      ,GroupName
      ,ModifiedDate
  FROM Department
  WHERE  Name LIKE 'E%';

 

image

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.