View Full Version : Micorsoft SQL Server 2005

06-18-2007, 06: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?


06-19-2007, 06: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