>>>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.
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos