incrementin ID

dark290790

kooshal
Local time
Tomorrow, 02:46
Joined
May 14, 2008
Messages
4
hey i hav an id of format ">LL000" e.g MG452,,am required to enter an id for every member who are new,,but i want it to incremen by 1 automatically,,how to do this??plzz help:(
 
Smart codes are a bad idea. But if you insist, store the numeric part in another column and either make it an autonumber column or get any new values for it via max(mycolumn) + 1.
 

Users who are viewing this thread

Back
Top Bottom