How to generate values from 001-088

Monika

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.

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

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.