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
May all your weeds be wildflowers