How can we help you today? How can we help you today?

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.
Monika
0

Comments

2 comments

Sort by
  • Eddie D
    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 D
    0
  • Monika
    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.
    Monika
    0

Add comment

Please sign in to leave a comment.