Re: ' in dynamic sql

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 06 Dec 2001 15:01:32 GMT
Message-ID: <3c0f8809.12667769@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:01:32 CST