Knowing and removing underscore records in table

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


UPDATE student SET sname = REPLACE(sname, '_', '')

Comments or Responses

Login to post response