Hi

I am getting a "... field does not accept null values" error on a SELECT statement. I am quite certain that the value of the field is null but dont understand why I am getting the error.

SET NULL ON
SELECT CAST(MyCalc(field1, field2) as N(5)) as calcfield ;
   FROM mytable ;
   INTO CURSOR tTemp

Can someone explain why my cursor wont accept null values and how I might get around the problem?

Regards
Geoff Scott