"Set define off" or "set define <to something else>". After that, find = the duhveloper who defined that table & shoot them. You'll be doing the = rest of us a favor. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Steiner, Randy [mailto:RASTEIN@xxxxxxxx] Sent: Wednesday, April 14, 2004 5:36 PM To: oracle-l@xxxxxxxxxxxxx Subject: escape column name I inherited a db with column names like: Close Date & Time I am having trouble querying these columns. When I put double quotes = around them, I get: Enter value for time: old 17: ,"Close Date & Time" Any help appreciated. Randy ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------