Stuart McLachlan
stuart at lexacorp.com.pg
Sat Jul 23 21:32:22 CDT 2005
On 23 Jul 2005 at 18:10, Joe Hecht wrote:
> What kind of SQL does Access use?
>
> Is it T- SQL ?
>
No, it's Access SQL.
It's similar to T-SQL in that the basic commands INSERT, SELECT, DELETE,
UPDATE, JOIN, WHERE, GROUPBY etc) and syntax are the same.
The main differences are that is uses standard Access/Windows wildcards
rather than the T-SQL ones ("*" = "%" and "?" = "_") and it uses VBA
functions in lieu of the T-SQL ones for type convertions, string
manipulation, conditionals (such as IIF()) etc.
--
Stuart