If this post helps you mark it as answer Thanks
SELECT * FROM student WHERE sname LIKE '%[_]%'
Cheers www.SQLServerbuddy.blogspot.com iLink Multitech Solutions
http://hashtagakash.wordpress.com/
Login to post response