Removing underscore records in the table

Posted by Satyapriyanayak under Sql Server category on 6/2/2013 | Points: 40 | Views : 1131

SELECT     sname
FROM         student
WHERE     (sname LIKE '%|_%%' ESCAPE '|')

or


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

Bookmark It

Latest Code Snipptes