UDFS: how do I specify a Boolean return type

[francisT]

Hi

I would like to write a User-Defined Function (UDF)
that returns a Boolean value. This would mean
that the UDF could be used where T-SQL syntax
calls for a Boolean expression.

Could someone tell me how I do this? The list
of scalar return types for UDFs does not include
a Boolean type, but I wonder if there is a
workaround, using some other scalar type (much
as in C and C++ Boolean expressions).

Regards

FrancisT

 

[fluteplr]

I would try using a tinyint. Return 1 for true and 0 for false.