Is there a more efficient way to write the following

IF(C._URLList IS NULL AND C._Website IS NULL THEN 0 ELSE C._ID) AS _URLsExist,

I don't think either IFNULL or COALESCE will work but I may be wrong

Roy Lambert

Roy,

<< Is there a more efficient way to write the following >>

Why ?  Is it slow ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< Is there a more efficient way to write the following >>
>
>Why ? Is it slow ?

I have no idea if its slow or not, I haven't timed it, but I like my code to be as efficient as I can make it eg after another discussion I've gone through and changed code like

IF(x is null then y else x)

to

COALESCE(x,y)

I haven't noticed any massive speed up but as I say I prefer to write efficient code.

Roy Lambert

Roy,

<< I have no idea if its slow or not, I haven't timed it, but I like my code
to be as efficient as I can make it eg after another discussion I've gone
through and changed code like >>

You won't find any difference between using IF() and nested IFNULL() calls.

--
Tim Young
Elevate Software
www.elevatesoft.com