In a "simple" sql statement, in general terms, is it better (ie does it run faster) to use CASE rather than IF? I'm rapidly coming to the conclusion that CASE is more readable than nested IFs.

Roy Lambert

Roy,

<< In a "simple" sql statement, in general terms, is it better (ie does it
run faster) to use CASE rather than IF? I'm rapidly coming to the conclusion
that CASE is more readable than nested IFs. >>

It really doesn't matter in terms of performance - both are compiled into
similar structures for execution.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Thanks, and in that case I'll use CASE

Roy Lambert