Home > DeveloperSection > Interviews > How To Use Wildcard Characters in LIKE Operations?

Posted on    November-09-2010 12:00 AM

 MSSQL Server MSSQL Server 
Ratings:
 1 Answer(s)
  871  View(s)
Rate this:

Amit Singh

Total Post:565

Points:2825
Posted on    November-09-2010 1:00 AM

Wildcard character '%' can be used in the pattern string for the LIKE operator to match any string of zero or more characters.

for example:

SELECT c.CompName FROM Company c
WHERE c.CompName LIKE '%Mind% Stick'

Don't want to miss updates? Please click the below button!

Follow MindStick