Underscores signify a single character in SQL language. Using LIKE for underscores will returns all values for ‘x’ whether they contain an underscore or not. Therefore, usage as shown below will not give the desired result:
Select x from MyTable where x like ‘%_%’
The correct usage is to use brackets, like ‘%[_]%’ as shown below:
Select x from MyTable where x like ‘%[_]%’