hi all!...
i have a small doubt... incase i have a database field for ID and i want my id to be of 5 digit field length... and append with zeros incase there are less than 5 digits...
example if the number is 34 it should become 00034
please help!.. thnx! n good day!
you should do this code side, rather than database side
34 = 00034 as far as numeric terms
if you want it display that way in a query use leading zeros
here's how to do it in sql server
http://www.sqlusa.com/bestpractices2005/padleadingzeros/
Thnaks a lot!... helped my requirement!...
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.