Question and Answer Database FAQ4240B.txt — SQL against Access tables with special characters in field names, such as # Category :Database (MSACCESS) Platform :All Windows Product :C++Builder1.0, C++Builder3.x, Delphi2.x, Delphi3.x, Delphi4.x, Question: How do I execute SQL against an Access table that has a special character in a field name, such as a #? Whenever I try my statement I get a "General SQL Error". Answer: Place [] around the field name. Example: SELECT * FROM Table WHERE Table.[Phone #] = '(831)431-1000' 3/26/99 10:24:18 AM
Last Modified: 01-SEP-99