Re: ' in dynamic sql

From: Allan Martin <allan.martin_at_saic.com>
Date: Thu, 6 Dec 2001 15:44:41 -0000
Message-ID: <3c0f21eb@cpns1.saic.com>

Thanks very much for getting back to me.

I was working along those lines, and it seems to be working.... apart from one thing. The data type I'm working with is a LONG, it complains on inconsistent datatypes if I try that.

Any advice?

Allan

"Nuno Souto" <nsouto_at_optushome.com.au.nospam> wrote in message news:3c0f8809.12667769_at_news...
> Allan Martin doodled thusly:
>
> >Hi,
> >
> >I have got a dynamic SQL statement which when build, the data which is
going
> >to be inserted into a table, may have the ' symbol in it. This means that
> >when I'm executing my SQL statement, the string is ended by the rouge ' .
> >Can anyone suggest anything?
> >
>
> Use the function REPLACE to make all the single quotes in the string
> double single quotes (as opposed to "rabbit's ears").
>
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Thu Dec 06 2001 - 09:44:41 CST