Escape character for parentheses?

[EllenM]

I'd like an escape character parentheses, so I can use "(letter)" as a
criteria.

Thanks in advance for your help,
Ellen

 

[Michel Walsh]

SELECT * FROM table WHERE field = "(letter")


or, in a context where you need it as a string


" SELECT * FROM table WHERE field = '(letter)' "

or

" SELECT * FROM table WHERE field = ""(letter)"" "




Vanderghast, Access MVP

 

[EllenM]

Thanks, Michel. "(letter)" worked as a criteria.

 

[Michel Walsh]

Yep, I made a typo in the first case, the closing parenthesis had to be
inside the string.


SELECT * FROM table WHERE field = "(letter)"



Vanderghast, Access MVP