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