Which operator performs pattern matching?

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


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