🚀 go-pugleaf

On Sat, 04 Apr 1998 11:49:26 +0800, EDDIE SHUM
<econshum@netvigator.com> shared these words of wisdom:

> This is the first time that I access this newsgroups and so a big hello
> to all you guys out there.  I have a couple of question to ask and would
> be grateful if someone could answer them :
Welcome.

> 1. What is wrong with my following SQL statement:
> 
> 	SELECT DATE_I_REC FROM PAYMENT_FORM WHERE DATE_I_REC > {15/02/98}
> 
> 	DATE_I_REC is a date field containing information on dates when
> invoices are received and PAYMENT_FORM is my file.   I have tried other
> combinations but nothing works.
Two things:
You don't use braces {} in SQL and dates must appear in m/d/y format.

Try SELECT DATE_I_REC FROM PAYMENT_FORM WHERE DATE_I_REC > 02/15/98

> 2. I read a few of the message this morning (it is morning now in Hong
> Kong) and it seems there is a CD issued by BORLAND on 'Teach yourself
> SQL in 21 days'?  I am reading a book of the same name (2nd edition)
> published by SAMS.  Is it the same book?  So, where is my CD?
I believe it is the same.  However, it was distributed only as a
promotional item with US versions of VdB.

Take care,
Gary