| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Ampersand sign in a string
Hello
I have Oracle SQL:
SELECT FES_LONG_DESCRIPTION From VERIFIERS
WHERE LOW_VALUE)='MO&TU' AND VERIFIERS.RV_DOMAIN)='DAYS';
The ampersand in the middle of the criteria string causes Oracle asking:
"Enter value for tu:"
How can I make this SQL so that 'MO&TU'
is taken as a whole?
Thank you.
Galina
Received on Fri Nov 30 2001 - 05:20:03 CST
 |
 |