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 |