>>>>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. :)

That's because I used BETWEEN() function and didn't subtract you keyboard's ENTER key lag time. :)))