Главная страница | назад





Article #19240: SQL against Access tables with special characters in field names, such as #

 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