Usin Parenthesis in LIKE does not work

[Larry Woods]

I am selecting a field with parentheses in it. My SELECT LIKE will not work. The field looks like this:

XXXXX (YYY)

I have tried the following and they DO NOT work:

SELECT FROM table WHERE field LIKE 'XXXX (%'

SELECT FROM table WHERE field LIKE 'XXXX \(%'


These DO work:

SELECT FROM table WHERE field LIKE 'XXXX %'

SELECT FROM table WHERE field LIKE 'XXXX _%'

On the other hand, this one does NOT work:

SELECT FROM table WHERE field LIKE 'XXXX _Y%'

What's the trick with parentheses?

Thanks