SQL
zoo.net
SELECT a column whose name contains spaces?
SQLite
DB2
Access
Postgres
Oracle
SQL Server
MySQL
Mimer
Sybase
Access
You can access columns where the name contains a space.
Execute tidy up
code
silently
DROP TABLE SpaceMonster
CREATE TABLE SpaceMonster([Account Balance] INT); INSERT INTO SpaceMonster VALUES (42); SELECT [Account Balance] FROM SpaceMonster
Specific to Access
Use square brackets.
Related links:
SELECT
Concatenate two or more fields.
Make union between different tables to build one single view or request?
Use 'like' in a sql select statement
How to build a statement on a word with an Apostrophe such as WHERE name='Tom's Book'
Full text search
Display a column name for an aggregate function.
How do you use Equi Join to join two tables with the same name.
Use SELECT for a column whose name contains spaces.
use NULL