SELECT statement convertion

[Serge Lobko Lobanovsky]

Does anyone need code to convert SELECT statements with INNER JOINs from SQL Server syntax to Access compatible syntax? Access requires brackets, as it is known. It's a weird thing, however, it's useful when you need to support both Access and SQL Server as backend, and don't want to duplicate the queries. Regards, Serge (Logic Software, Easy Projects .NET site)

[WillemM]

You can also use brackets in SQL, so you can write the queries for Access and re-use them on SQL server :) "Every rule in a world of bits and bytes can be bend or eventually be broken"