Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2011

    Unanswered: How to add data to column


    How do i add random 9 digit numbers to each row for the entire column?

    Please and thank you for your help.

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Please give an example that includes at least three rows of dummy data with an example of what you consider a "random 9 digit number" so that we can better understand what you want. Do you want a new column added to every row? Do you want these digits put into an exisiting column, and if so are the right, left, or otherwise justified? How do you deal with leading/trailing zeros on the random numbers?

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    Use the RAND ( [ seed ] ) function and supply a unique numeric value (such as an identity) as the seed.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts