Hi Folks,

I'm using 8.1.6 on AIX.

I'm trying to decode a value that contains a '&' and replace it with another field (See below). However when I run the statement it prompts me for a value for Gen. It thinks the '&' is for user input. Does anybody know how to accept the 'Bill & Ben' and not to prompt for an input for Ben????

(decode(avc_element_1,
'Bill & Ben ', ytd_avc_ded_cash_1, 0))


thanks for any help

Moff.