Re: [SQL] Variable-length Types

> It takes a string and returns something that looks like Varchar(22); > If someone types in 10 digits, it returns output like (###) ###- > If a user enters 7 digits, it picks a default area code and returns > (415) ###-, > and if they type more than 10 digits or enter any digits after an

Re: [SQL] variables in SQL??

> what im trying to do is have a Sum of a colum.. as it goes forwards I don't think this is what you want, but I suppose it might help Table= simple +--+--+- --+ | Field | Type

Re: [SQL] Functions with Null Arguments?

I would try using COALESCE(list) which will return the first non-NULL in the list. - Original Message - From: Thomas Swan To: [EMAIL PROTECTED] Sent: Tuesday, August 15, 2000 3:18 AM Subject: [SQL] Functions with Null Arguments? Is there anyway way to get the

Re: [SQL] problem with view and case - please help

Instead of: > WHEN $1 LIKE \'Mozilla/2.0 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT > LIKE \'%compatible%\' THEN \'Netscape 2.0\' > WHEN $1 LIKE \'Mozilla/2.02 %\' AND $1 NOT LIKE \'%MSIE%\' AND $1 NOT > LIKE \'%compatible%\' THEN \'Netscape 2.02\' > WHEN $1 LIKE \'Mozilla/2.02E %\' AND $1 NOT LIK