Subject Re: [ib-support] [] or ""
Author Woody
From: "Paul Schmidt" <paul@...>
> The basic question is, is there an SQL standard way of doing the
> same thing? If there is then it should be adopted... Otherwise,
> sure why not "Joe Blough" <> "JOE BLOUGH" but [Joe Blough] =
> [JOE BLOUGH] However it should happen for dialect 5 (they went
> from 1 to 3, so I assume the next one is 5). So that it doesn't
> "break" any existing code that might be out there.

Exactly. As far as I know, there is no standard for this syntax because I
don't think there was ever a need. MS's bracket concept is used primarily to
allow the use of spaces in table and field names. The brackets are optional
in query statements but must be used if the name contains any special
characters, such as space, hash, etc.

AFAIK, brackets are not used anywhere in the SQL-92 standard right now. So,
adding them for this case shouldn't hurt anything in previous versions.
However, I am of the opinion that it would be much better for the standard
to be changed and adopted in SQL-92 rather than just in IB or FB. Anyone
know how to make these types of suggestions to the great SQL gods that write
the standards?