Home > DeveloperSection > Interviews > How and when to use LIKE statement?

Posted on    February-01-2011 12:00 AM

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

Vikas Giri
Vikas Giri

Total Post:33

Points:165
Posted on    February-01-2011 1:00 AM

we use "like" in query as

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern

and used to search for a specified pattern in a column.

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

Follow MindStick