SELECT * FROM MyTable WHERE MyField LIKE'%\[signature]%' ESCAPE '\'
>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?