Migrating Delimiters, Operators, Constants, and Wildcard Characters from Access to SQL Server

This table shows the Microsoft® SQL Server™ equivalent for each Microsoft Access term.

Description Access SQL Server
Date delimiter # '
String delimiter " '
Mod operator mod %
Concatenation operator & +
Wildcard character ? _
Wildcard character * %
Constant Yes 1
Constant On 1
Constant True 1
Constant No 0
Constant Off 0
Constant False 0


(c) 1988-98 Microsoft Corporation. All Rights Reserved.