Escape character for parentheses?

E

EllenM

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

Thanks in advance for your help,
Ellen
 
M

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
 
M

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
 
Top