That's pretty simple. Was possible for fields have NULL values before CAST() was impemented?

Regards
Geoff

>

>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