How to generate values from 001-088

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:

Answers

  • Eddie DEddie D Posts: 1,805 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
  • 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. 
Sign In or Register to comment.