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 |