select * from tb_whatever where whatever like '%[_]%'
Just wrap the underscore in brackets.
'%[_]%' Kind of looks like a face, eh? Your SQL Server is watching you.... :)