Hello Howell, See URL: http://www.mysql.com/doc/en/Legal_names.html for the solution.
Basically enclose FILE# with `, e.g. where `FILE#` = 1332 Bernard On Thursday 29 January 2004 12:55, Howell, Scott wrote: > I am trying to query a table that has field names with # characters in > them. For example a table emp_earn has a field called FILE# > > I need to do a query where FILE# = 1332, but anything I try errors out. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]