I have a UDF called myUDF, which returns a numeric data type.

?myUDF(parm1,parm2)
correctly returns a numeric data.

SELECT myUDF(parm1,parm2) FROM myTable
gives me a 'Data Type Mismatch' error.

I've stepped through the UDF & all is fine until I hit the last statement:
RETURN xRet
(where xRet is the return value).

Anybody knows what's wrong?
Thanks all!