How to auto increment with character + integer?

Question

I have created a table and with a primary key called ID. However I want the ID be auto increment as well. Here is my question how can I do in the following format: Air0001  Air 0002  Air 0003 ............ etc.

Murugesh P · Answer

Try This CREATE TABLE TABLE ( IDNo int IDENTITY NOT NULL  ID as 'AIR' + Cast ( IDNo as Varchar ( 10 )) PERSISTED PRIMARY KEY  )

pritaeas · Answer

Just use an identity column for the id part and format it the way you want in your query or in your front-end.

How to auto increment with character + integer?

I have created a table and with a primary key called "ID". However, I want the "ID" be auto increment as well. Here is my question, how can I do in the following format: "Air0001", "Air0002", "Air0003", ............ etc.