searching for a '

Asking for help in searching a varchar2 field for a ' character. I try using the escape character in SQL plus as a / but no luck:

SQL> show escape
escape "\" (hex 5c)

SQL> select * from "ODB"."RELATION_MASTER" R WHERE R."RELATION_TRANSACTION" = 'EMPLOYEE' AND R."NAME" = '\'' ;
ERROR: ORA-01756: quoted string not properly terminated

I'd also like to be able to put that query in a cursor in a stored procedure, but it doesn't let me compile that in Enterprise Manager.

I'm using 9i on Win2000

--
Luciano Belotto
replace spam with traxsoftware for e-mail