Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-11 : 08:10:00
|
| mbako writes "Hello,is it possible to generate an unique id like this "1AA00002 in sql.Please help Thanks,Mbako" |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2005-04-11 : 09:03:42
|
| You need to clearly define all of the rules for how this value is incremented before you can even start to think about how to implement it in any programming language.- Jeff |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-04-11 : 09:07:28
|
| Select '1AA'+convert(varchar(5),(right(max(right(column,5))+'00001'+1,5)))MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
auto id format "1AA00005"