This content has been marked as final. Show 4 replies
How to create Random Values in an existing table with numerical, text, and null values in a single field?
Create random OrderID's starting from 2001 to 190000, some of these must be null and some should say "No Order ID". This would all be in an OrderID field.
I already have a table I just have to create the above in there. Any idea how to do this?