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





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