Home > Interviews > Sql Server >

Which operator performs pattern matching?

 Posted by Abhisek on 1/21/2010 | Category: Sql Server Interview questions | Views: 2165
Answer:

LIKE

SELECT * FROM student WHERE name LIKE '%Abhisek%'


The above command will retrieve records with name Abhisek in the name column.

We can use different wildcard characters to specify the condition.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response