Same syntax on MySQL and Microsoft SQL Server

[Christian Reichenbach]

A few months ago I tried to use MySQL as an alternative database
backend for our software product. Currently we are using MS Access and
MS SQL Server.

We encountered that MySQL (or MyODBC) uses different quoting
characters for legal names and strings. At present we are using square
brackets for names (like [my table], [my column] or
[my table].[my column]) and inverted commas for strings (like mytxt =
'text').

Is there an option for MySQL (or MyODBC) which makes basic SQL of
these databases compatible?

Thanks
Christian

__________________________________________________________________

Gesendet von Yahoo! Mail - http://mail.yahoo.de
M