Okay -

So I have a basic table - 100 Columns - ALL VALUES, when populated, there are NULL values entered instead of 0 ( zero ).

So want to scan the fields and replace NULL with 0 (zero)

update BasicTable

for count = 1 to maximumnumberoffields

if fieldname[count] is null

set fieldname[count] = 0

endif

next

something like that !?