Re: WHERE clause with an & not meaning it to be a variable

From: Vince <vopipari_at_ehealthcontracts.com>
Date: 6 Nov 2001 13:58:54 -0800
Message-ID: <8d71f979.0111061358.7c08654a_at_posting.google.com>


flored_at_mail.conservation.state.mo.us (Diane) wrote in message news:<52086d5b.0111061053.4e079afd_at_posting.google.com>...
> I have the following sql statement in sql plus:
>
> select * from raptor.tblaccounts where accaccountdesc = 'ADMIN & HUMAN
> RESOURCES';
>
> It thinks that the "&" is to be used as a variable and I want it to be
> straight text. How do I force sql plus to view it that way?

Change 'ADMIN & HUMAN RESOURCES' to 'ADMIN '||CHR(38)||' HUMAN RESOURCES' Received on Tue Nov 06 2001 - 22:58:54 CET

Original text of this message