On Mon, Apr 08, 2002 at 11:01:43AM -0400, Kong, Alan wrote: > > I'm using PERL DBI to query the data from Oracle database. In my SQL, there > is a '&' character in my where clause, so that I can't get my result set. > Can somebody tell me how can I set the scan off? Thanks. >
You might try adding an escape clause, e.g. .... WHERE mycolumn = 'foo\&bar' ESCAPE '\' Ronald
