[AccessD] Access SQL

Jim Moss jim.moss at jlmoss.net
Mon Jul 25 10:16:36 CDT 2005


You can optionally set the database to use SQL Server compatible syntax
(ANSI 92) in the options menu.


> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>





More information about the AccessD mailing list