FW: [WEB4LIB] FW: SQL/ASP query

[Gimon, Charles A]

Surprisingly recent, it seems:

http://hyperarchive.lcs.mit.edu/telecom-archives/archives/history/octothorpe
.the.real.story

No way was I going to call it a "pound sign" to someone from the UK,
anyway...

--Charles G.

-----Original Message-----
From: Julia Schult [mailto:jschult at elmira.edu] 
Sent: Wednesday, October 04, 2000 1:49 PM
To: CAGimon at mpls.lib.mn.us
Subject: Re: [WEB4LIB] FW: SQL/ASP query


"octothorpes"?
How long has that term been around?

"Gimon, Charles A" wrote:

> 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.

--
---Julia E. Schult
Access/Electronic Services Librarian
Elmira College
Jschult at elmira.edu