I want to create a function like IIF in Microsoft Access. But SQL Server 2000 do not have boolean data type. Someone told me bit could be alternative.
The question is, if I define function like:
create function IIF(@boolexp bit, @tv sql_variant, @fv sql_variant) ...
I could
SELECT IIF(COLNAME*3, 'T', 'F') FROM TABLENAME
but could not use
SELECT IFF(COLNAME > 3, 'T', 'F') FROM TABLENAME
So, how to solve that?
Thanks a lot.