On Tue, 16 Oct 2001 09:02:05 -0600, Sterin, Ilya wrote:
>It might be getting a little bit OT, but I searched and couldn't find the
>right definition of Jet SQL.
>
>Microsoft claims it's close enough to the standard (though nowhere does it
>say in conforms to any standard).
Well...
First of all, Access uses [ and ] for field name delimiters, instead of
the standard double quotes, doubles or single quotes instead of single,
around text, and DOS/glob-like "*" and "?" for the wildcard characters,
instead of the standard "%" and "_". And table and field names are case
insensitive.
SELECT * FROM [my table] WHERE [first name] LIKE "B*"
But this is for queries built an ran inside Access only. For SQL invoked
through DBI+DBD::ODBC, you'd better stick to the standard syntax:
SELECT * FROM "my table" WHERE "first name" LIKE 'B*'
In fact, You can almost use both syntaxes through DBI, except that "*"
and "?" for wildcards doesn't work. YOu have to use the standard "%" and
"_".
Furthermore, internally Access allows calling functions in Access Basic
in a query, but apparently not through DBI.
--
Bart.
