[AccessD] Access SQL

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





More information about the AccessD mailing list