>>>sele val(.null.)+000000000 as testno,* from table1
>>
>>Thanks Ed! Didnt think of that :)
>
>He _is_ a genius, is he not? :)


Boy I'll say. I would never of thought of doing some kind of calculation with a .null. for any reason.