I have a table that contains null values, I need to populate this field with a random number in order for it to fit into my link table.
Can anybody recommend the best loop approach to do this, my table does contain a min and max order number that I could use to control the loop.
Something like this maybe:
,if(len(trim(MyField))=0, autonumber(rand()),MyField) as MyField
Try autonumber() or RecNo() or RowNo() Functions...
Thanks guys, is there anyway you can dictate the starting number in an autonumber command, for example I might not want it to start at 1.
Retrieving data ...