RE: Use of ampersand (&) within string

Thanks, Michael.

That's done it.

Also on suggestion from Christopher:

>>>> Set define off
>>>> Will ignore & in a sql script. Then do what Michael suggests and F5.

On Behalf Of Michael Staszewski
Sent: Wednesday, May 09, 2012 10:12 AM

Do the same in Toad as you would in SQL*Plus, but execute as a script. It's the toolbutton with a lightning bolt on top of a page image or F5.

From: [email protected] [mailto:[email protected]] On Behalf Of Lovelady, Dennis E.
Sent: Wednesday, May 09, 2012 9:53 AM


We have an income code in our Payroll system for Time and Expenses = 'T&E'

I cannot seem to find a way to tell TOAD that that ampersand is part of the string I want to search in an SQL (not PL/SQL) session.  I know that I can do this with SQL*Plus by using SET DEFINE <some_non_ampersand_character> but I do not see a way to do it with TOAD.

Can you help?

Thanks!





_____________________________________________________________
DTCC DISCLAIMER: This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error, please notify us immediately and delete the email and any attachments from your system. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email.



<BR>_____________________________________________________________
<FONT size=2><BR>
DTCC DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error, please notify us immediately and delete the email and any
attachments from your system. The recipient should check this email
and any attachments for the presence of viruses.  The company
accepts no liability for any damage caused by any virus transmitted
by this email.</FONT>