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:[EMAIL PROTECTED] Sent: Monday, July 21, 2003 4:58 AM To: [EMAIL PROTECTED] 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/
