>>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!
:)
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison