Re: AMPERSAND in where clause mistaken for variable name

Jude,

Prior to the query enter the following:

        set define ~

This will change the define symbol from & to ~ (tilde). You may use any character that you want. This must be placed inside of your sql file and will remain set until the seesion is over or you execute "set define" again.

DER

-- 
David Richardson
2026 Aquia Drive
Stafford, VA 22554
1-800-425-6719
drichardson_at_all-4-one.com
http://www.all-4-one.com