select * from table where title=translate('KEYWORD', '''', '"')

Richard Quintin
VTLS, Inc.
http://www.vtls.com/

-----Original Message-----
From: sean feifer [mailto:[Email Address Removed] Sent: Wednesday, July 31, 2002 9:24 AM
To: Richard Quintin; LazyDBA.com Discussion
Subject: RE: Single Quote in Select Search


That is a good point. But how can I incorporate it into my statement so
that it catches ' and convert to " when receiving a value containing '. The
statement is "select * from table where title='KEYWORD' " Pls note the
KEYWORD servers a variable. It does not always contain ' . I want the SQL to
catch a value either with or without '. That means I need to have a function
to attach to the SQL so that it can convert ' to '' if it sees one.

Thanks!



Oracle LazyDBA home page