SELECT CAST(MyCalc(field1, field2) as N(5) NULL) as calcfield ;
...

>
>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