agravayne Posted April 18, 2008 Share Posted April 18, 2008 Hello All, Not sure of this is possible but I need to create a table with an autoincrement to a specific format. it shuld be 10 didgits ling and start with 03. I could just start the autoincremet at 300000000 but of course there's no leading zero. Has anyone got any ideas? Scott Quote Link to comment Share on other sites More sharing options...
fenway Posted April 18, 2008 Share Posted April 18, 2008 Hello All, Not sure of this is possible but I need to create a table with an autoincrement to a specific format. it shuld be 10 didgits ling and start with 03. I could just start the autoincremet at 300000000 but of course there's no leading zero. Has anyone got any ideas? Scott Well, in theory you could use ZEROFILL, but I would recommend use a normal column and then simply LPAD() it on the way out. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.