Micorsoft SQL Server 2005

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:

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...