I need to get results where the column contains a string that includes
[ ]. When I use
LIKE, it takes the
 as a wildcard sequence, and doesn't work as I need.
For example, I want to search through a column called
Address and get any values where the string contains
SELECT * FROM Location WHERE Address LIKE '%[Sydney]%'
I can't use
CONTAINS(), because this is not a full-text indexed column.