4 Replies Latest reply: Apr 15, 2016 8:24 AM by John Blomqvist RSS

    How to create Random Values in an existing table with numerical, text, and null values in a single field?

    John Blomqvist

      Hi all,

       

      How to create Random Values in an existing table with numerical, text, and null values in a single field?

       

      For example:

       

      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?