Why not store varchar(6) prefix int suffix
so you could store ABC-DE and then your suffix - each time you "generate" a new code you simply call a stored proc which will increment the suffix and return prefix & suffix. On Sun, Nov 29, 2009 at 8:24 PM, aditya chavan <[email protected]> wrote: > code is a mixer of string and intiger and my data base is MS SQL 2005 > so which would be better...?? > > > On Sun, Nov 29, 2009 at 10:07 PM, Cerebrus <[email protected]> wrote: > >> string ? varchar ? >> >> On Nov 28, 9:49 pm, aditya chavan <[email protected]> wrote: >> > what datatype should be >> > kept in database >> > >
