I need to use a special character in a query and this causes me some problem. Basically, I need to search for:
SELECT * FROM MyTable WHERE MyField LIKE'%[signature]%'
However, the [ and ] characters are reserved and this creates a weird result. How can I adjust that query to make sure that [ and ] are really interpreted as a character?