On Mon, Mar 21, 2005 at 12:35:22AM -0600, Thomas F.O'Connell wrote:
> The number of lines depends merely on where you place your line breaks.
>
> IF(days_complete <= 120, job_price, 0)AS Days_120
>
> could be written as:
>
> CASE WHEN days_complete <= 120 THEN job_price ELSE 0 END AS Days_120
>
> There might be somewhat less syntactic sugar, but this is not a five
> line expression and, to me, is more readable than a comma-delimited
> list where position alone indicates function in the expression.
CASE is also standard SQL, whereas IF isn't (unless I've overlooked
it in the SQL:2003 draft).
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/