Types of delimiter in SQL
The type of delimiter that surrounds each value in an SQL statement depends on the datatype of the receiving column and on the database system. Here's a quick summary:
| Type | Access | SQL Server |
| Numeric | none | ' or none |
| Text | ' | ' |
| Date | # | ' |
Published Thursday, June 03, 2004
