Re: Complex String for Insert.
From: Digiital <torontodss_at_hotmail.com>
Date: 9 Jan 2002 07:33:15 -0800
Message-ID: <c874dd0a.0201090733.3a4ffa9e_at_posting.google.com>
Date: 9 Jan 2002 07:33:15 -0800
Message-ID: <c874dd0a.0201090733.3a4ffa9e_at_posting.google.com>
billiauk_at_yahoo.co.uk (billiauk) wrote in message news:<dee17a9f.0201090043.6739f52f_at_posting.google.com>...
> Try using REPLACE function around your string to replace all single
> occurrences of ' with ''.
>
> HTH
Thanks a million, that did the trick.
I ended up using:
REPLACE( <text> ,CHR(39),CHR(39)||CHR(39)) Received on Wed Jan 09 2002 - 16:33:15 CET