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

From: Andrew Barnett <nobody_at_spamandeggs.bp.com>
Date: 1998/03/20
Message-ID: <01bd53a1$ca75cdc0$8c0564a1@azmelw1358.mel.az.bp.com>#1/1

use 2 quotes - thus:

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

-- 
Andrew - Wizzard

barnetaj_at_bp.com

Peter Smith <psmith01_at_mindspring.com> wrote in article
<3511B75E.118CF2DE_at_mindspring.com>...


> 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 Fri Mar 20 1998 - 00:00:00 CST