Re: SELECT a field with special chars. like a \'

select * from <some_oracle733_db_on_nt>

        where <somecolumn> = 'D''Angelo'

On Thu, 19 Mar 1998 19:25:02 -0500, Peter Smith <psmith01_at_mindspring.com> wrote:

>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
>

Kind regards,
Jeff Iverson

-- 
 The Directory of Computer Consultants & Developers
 http://www.iversonsoftware.com/cgi-bin/randombanner.cgi
 21 Devonshire Pl., Mankato MN  56001-4984
 507-386-6208 - j5rson_at_iversonsoftware.com