...

View Full Version : Micorsoft SQL Server 2005



Lis716
06-18-2007, 07:20 AM
hi there!

I need help on how to create alphanumeric autonumber in SQL... like for example: HP1, HP2, HP3

is there other way aside from creating it in codes?

thanks!!!:thumbsup:

javabits
06-19-2007, 07:37 PM
Well you can either use concat with a string literal or two seperate columns.

so something like

select concat('HP', ID) from table

semper fi...



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum