Removing underscore records in the table

Satyapriyanayak
Posted by Satyapriyanayak under Sql Server category on | Points: 40 | Views : 697
SELECT     sname
FROM student
WHERE (sname LIKE '%|_%%' ESCAPE '|')

or


SELECT * FROM student WHERE sname LIKE '%[_]%'

Comments or Responses

Login to post response