In article <[EMAIL PROTECTED]>, Michael Fuhr <[EMAIL PROTECTED]> writes:
> 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). CASE, despite being standard SQL, is even supported by MySQL ;-) ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend