Fred Williams wrote:
If brackets are a visual distraction, more common " Quote Marks may be
used as well.
Not only are double quote characters more common, they are the standard
method for quoting names in SQL. The square brackets are a non-standard
extension introduced by Microsoft in Access. You should stick to the
standard double quote for better compatibility with other databases engines.
create table t (id integer primary key, "order" integer, "a long name"
text);
select "a long name", "order" from t;
HTH
Dennis Cote