Jet 4 provider SQL Operators and Functions

[Ruben Tieland]

Hi,

Is there a list of what SQL Operators and Functions can be used with the Microsoft.Jet.OLEDB.4.0 Provider to query a access database.

thanks in advance,
ruben

 

[Michel Walsh]

Hi,


There is a list of reserved words...
http://support.microsoft.com/?id=321266

Note that the list is not complete, for what you seek, since iif can be
used, but it is not listed. You can also take a look at
http://support.microsoft.com/?id=239482



Hoping it may help,
Vanderghast, Access MVP

Hi,

Is there a list of what SQL Operators and Functions can be used with the

Microsoft.Jet.OLEDB.4.0 Provider to query a access database.