| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Underscore "_" character problem
Dear Richard,
Try using this where condition.where product_code like '728$_' ESACAPE '$'.
Escape '$' is used for telling the system to match the character '_' and not for
any character.
You can also use SUBSTR function in the where class;
where SUBSTR(product_Code,1,4) = '728_'
R.Bala Received on Tue May 30 2000 - 23:33:29 CDT
 |
 |