>>my code is.
>>select get_percent(my_fld) as my_percent
>>
>>I am getting an error message saying..MY_PERCENT DOES NOT ACCEPT NULL VALUES.
>>I want my_percent to accept null values and need to know how to
>>code the SELECT to include the NULL keyword..any ideas?
>
>Hi Robert,
>
>Could you please show more code to help you with this problem. Meanwhile, take a look into nvl() function in Help.
--------------
Hi Nadya and Happy Thanksgiving,
I fix the problem...I had to test the fld value...my code
if isnull(myfld)
myfld = 0
endif
that did it.........:))