FW: [WEB4LIB] SQL/ASP query

[Gimon, Charles A]

Couple of little things that haven't been mentioned yet:

Escaping the single quote: if you want to include a ' in a string in your
SQL statement, use two of them: ''

For example: SELECT ID, NAME FROM EMPLOYEES WHERE DEPT = 'Children''s'

Also, Access wants dates in SQL statements to be bracketed by octothorpes:

SELECT RECORD FROM TABLE WHERE DATE > #2/1/2000#

--Charles Gimon
  Web Coordinator
  Minneapolis Public Library


-----Original Message-----
From: Ian Winship [mailto:ian.winship at unn.ac.uk] 
Sent: Wednesday, October 04, 2000 6:40 AM
To: Multiple recipients of list
Subject: [WEB4LIB] SQL/ASP query


[...]I am also a little unclear about the placing of single and
double quotation marks in the statement.