Re: Apostrophie Problem

From: Mark Wagoner <mwagoner_at_iac.net>
Date: Wed, 17 Jan 2001 16:10:16 -0500
Message-ID: <9451no$97t$1@genma.iac.net>

You have to do an instr() and replace any single quotes with two single quotes.

"Perry Hemmings" <perry.hemmings_at_btinternet.com> wrote in message news:944vhs$fl8$1_at_uranium.btinternet.com...
> Hello All
>
> I am running Oracle 8 with a Visual Basic frontend, my program falls over
> when an Apostrophe is in the name i.e. O'Brien and my search needs
adjusting
> can anyone advise me on how to achieve this??
>
> Res = "SELECT Lastname FROM Customer WHERE Lastname = txtTEXTBOX"
>
> Thanks in advance
>
> Perry
>
> Please e-mail your response to perry.hemmings_at_volteurope.com as well as
> responding to the NG
>
>
Received on Wed Jan 17 2001 - 15:10:16 CST