Re: Escape sequence

Mark wrote:
> I have a query I use to validate that there are no other records with
> the same descriptions - a table for items.
>
> Now the querry ends up like this:
>
> SELECT COUNT(ITMID)
> AS COUNT
> FROM
> TBLITEM
> WHERE
> ITMDESCRIPTION = '26g Galvalum Wide - Flat Sheet's'
> AND
> ITMID != 707
>
> Where the 707 refers to itself. But the Sheet's' will not work. Says
> "ORA-00933: SQL command not properly ended".
>
> Can someone help me with this? is there a way to escape the '?
>
> Thank you,
> Mark
>

Another simpler example from the scott user is this: select *
from emp
where
ename = 'ADAM'S'

This gives the same result. How can I escape the single quote in ADAM'S?

Thanks you,
Mark Received on Wed Aug 27 2003 - 22:54:48 CEST