problem with ampersand

From: Ford Desperado <ford_desperado_at_yahoo.com>
Date: 21 May 2004 11:13:26 -0700
Message-ID: <e96bc0d0.0405211013.6f35bb13@posting.google.com>

Hi,

I'm trying to create a function that includes this line:

CHR(13)|| 'Run Type: ' || (CASE SD_RUN_TYPE WHEN 1 THEN 'Manual' WHEN 2 THEN 'L&L' ELSE 'Automatic'

when I run the script via either SQL*Plus or TOAD, I get a prompt:

Enter value for l: 1
old 97: CHR(13)|| 'Run Type: ' || (CASE SD_RUN_TYPE WHEN 1 THEN
'Manual' WHEN 2 THEN 'L&L' ELSE 'Automatic' END) ||
new 97: CHR(13)|| 'Run Type: ' || (CASE SD_RUN_TYPE WHEN 1 THEN
'Manual' WHEN 2 THEN 'L1' ELSE 'Automatic' END) ||

which means I'm getting 'L1' instead of the 'L&L' token that I need. Although I already have a workaround, I'm quite curious why would that happen

TIA Received on Fri May 21 2004 - 13:13:26 CDT