>>>Is there an equivalent of FoxPro's IIF() function in T-SQL?
>>
>>
CASE WHEN fld1<0 THEN 0 ELSE fld1 END
>
>Might be a new UT responce time record: 29 seconds!
>:)
Looks like you used floating point calculator to get the time difference between question and answer. :)
Your result is off by 2 seconds. :)
--sb--