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

Posted on    February-01-2011 12:00 AM

 MSSQL Server MSSQL Server 
 1 Answer(s)
  1402  View(s)
Rate this:

Vikas Giri
Vikas Giri

Total Post:33

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