Hi, Brian.  There's tons of stuff out there.

http://www.google.com/search?hl=en&ie=ISO-8859-1&q=SQL+tutorial+cast
        http://www.firstsql.com/tutor3.htm#special

http://www.google.com/search?hl=en&lr=&ie=ISO-8859-1&q=SQL+tutorial+substr
        http://abdi.isse.tripod.com/sql/calc.html

Alex Paschal
Freightliner, LLC
(503) 745-6850 phone/vmail


-----Original Message-----
From: brian welsh [mailto:brianwelsh3 AT HOTMAIL DOT COM]
Sent: Monday, July 21, 2003 4:58 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Learning SQL-queries


Hello,

On the list I see on a regular base sql-queries with something like this:
- CAST(SUM(BYTES/1024/1024)
or
- substr(cast(min(start_time) as char(26)),1,19) as "DATETIME
or
- cast(substr(cast(max(end_time)-min(start_time) as char(20)),3,8) as
char(8)) as "Length

The basic sql I understand now, but I want to know more about 'substr' and
'cast' and so on. Is there some-one who can give me the title of a book
where this is explained or maybe an url or something?

Thanks in advance,

Brian.

_________________________________________________________________
Chatten met je online vrienden via MSN Messenger. http://messenger.msn.nl/