>>>Ok here's a weird one I think. I want to run a SQL Select that creates a numeric field of a specific size, but have it populated with nulls.
>>>
>>>I tried:
>>>
>>>SELECT *, VAL(.null.) AS testno FROM sometable
>>>
>>>This gave me a field called testno thats N,1. I need to make testno N,9 yet still have it populated with all null values. Can I do this without doing the SELECT with 9 zeros AS testno then REPLACE ALL to fill with nulls? TIA!!
>>
>>sele val(.null.)+000000000 as testno,* from table1
>
>Thanks Ed! Didnt think of that :)
He _is_ a genius, is he not? :)
Marc
If things have the tendency to go your way, do not worry. It won't last. Jules Renard.