What are the challenges you face when working across database platforms? Take the survey

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.


  • Options
    Eddie DEddie D Posts: 1,792 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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Options
    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.