Re: Using the & in a string

From: Lee J. <ljeznach_at_csi.com>
Date: Fri, 22 Dec 2000 23:12:32 GMT
Message-ID: <AdR06.135527$_5.29998650@news4.rdc1.on.home.com>

some people advice to use ESCAPE but in fact none of them know exactly how to use it
otherwise they would give you an example.

e.g. mystring := '/&abcd'; doesn't work
but mystring := '/&' || 'abcd'; is ok.

"Bill Hutchison" <billh_at_gci.net> wrote in message news:t3fqqbli4mgoa9_at_corp.supernews.com...
> I'm trying to include an ampersand within a string in a sql script, and
I'm
> being prompted to enter the value of Safety when I run it.
>
> The string looks like
> 'Plant Health & Safety Check List'
>
> How can I make it recognize the entire string?
>
> Thanks for your help!
>
>
Received on Fri Dec 22 2000 - 17:12:32 CST