[AccessD] Access/SQL Dates

You are incorrect.  The single quote (') is the correct delimiting character
to replace the pound sign (#) used by Access.  The percentage symbol (%) is
the character to use when doing a LIKE search -- Access used an asterisk
(*).

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Monday, September 27, 2004 11:19 AM
To: 'Access Developers discussion and problem solving'; 'Nicholson, Karen'
Subject: RE: [AccessD] Access/SQL Dates


Very probably I am wrong as I've not yet had the joy of dealing with SQL
server, but is it not the case that the date delimiting character in SQL
Server is the percentage symbol (%) not pound or hash (#)?

Lambert