SQL Server

Knowing and Removing the Underscore Records in a table

To find the underscore records in table

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

Or

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


To remove the underscore records in table


UPDATE    student SET    sname = REPLACE(sname, '_', '')
Ebook Download
View all
Learn
View all
Membership not found