From: Howell, Scott [mailto:[EMAIL PROTECTED] > 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.
I can't seem to even create a table with a column with a # in the name. However, have you tried enclosing the column name in backticks? SELECT * FROM table WHERE `FILE#`=1332; -- Mike Johnson Web Developer Smarter Living, Inc. phone (617) 886-5539 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]