How to generate values from 001-088

MonikaMonika Posts: 2 New member
in SQL Data Generator
I wanted to generate values from (001-088) How can this be achieved. The zero in the prefix is getting truncated while using the ID generator.Kindly help.Many Thanks.
Tagged:
· Share on Twitter

Answers

  • Eddie DEddie D Posts: 1,803 Rose Gold 5
    Hi Monika, thank you for your forum post.

    Yes, the number generators do truncate the prefix zero's.  I have even tested using a csv file as the source and the prefix zero's are still removed if the datatype of the column is an int.

    Testing against a CHAR or VARCHAR column, using a csv file I was able to keep the prefix zero's.

    I hope the above answers your question.

    Many Thanks
    Eddie




    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
  • MonikaMonika Posts: 2 New member
    Hi Eddie
    Thank You for your response. I have changed the int to varchar and directly input the values with 5 digit ID generate option. 
    · Share on Twitter
Sign In or Register to comment.