On Feb 6, 2008 9:50 AM, Fidel Viegas <fidel.viegas@...> wrote:

> In MS SQL Server, you replace the "" with [ and ]

I forgot to mention that MS SQL also supports "". That has to do with
the QUOTED_IDENTIFIER option. I don't really remember as I haven't
really worked that much with SQL Server. I know that it does support
both "" and []. If QUOTED_IDENTIFIER is on, then you use "", if it is
OFF, then you use []. There is one thing you have to remember though.
If you set QUOTED_IDENTIFIER to on, then it will work similar to
Firebird. That is, you use "identifier name" for identifiers and 'text
value' for text. If you set it to OFF, then you use [identifier name]
for identifiers and "text value" for text.

Just to make sure, have a look at the user manuals.

All the best,

Fidel.