SELECT a field with special chars. like a \'

I need to do the following:

Select * from <some_oracle733_db_on_nt> where <somecolumn> = '<some_value>'

The problem I'm having is that '<some_value>' may be "D'Angelo" which yields:

Select * from <some_oracle733_db_on_nt> where <somecolumn> = 'D'Angelo'

thus producing a syntax error. What's the work-around??

Thanks.

--Peter--
psmith01-at-mindspring.com Received on Thu Mar 19 1998 - 00:00:00 CST