How To Auto Increment With Character + Integer?

Hi,

I think there is no need to maintain the Auto Increment Id with Characters & integers.

Simply create an Identity Column in your table which should be increment by 1.

Now while fetching the data from DB, you can use below query (eg.) for displaying the Character + Integer id

SELECT 'PIC' + RIGHT( '000000' + CAST(ID AS VARCHAR),7) FROM YOUR_TABLE

Here I am assuming, PIC as fixed string

You will get the required output.

Try above.

Hope this will help you.


Cheers

Create A Function That will take AutoID as a parameter, now manipulate inside that function
as per your requirement .

Then create a separate column which will have that function in Table Definition & use this new
column.

I don't have as such demo but let me know which is not clear to you or do you want me to
write code for you?