Create Custom ID for Table 1

[alexanderthegreat]

I want to create a custom ID for my orders table so that it assigns a number like ORD00001 automatically.
As the next order is placed it will enter ORD00002 etc..

How can I accomplish this?

Al

 

[r937]

use a computed column to define a concatenation of the string 'ORD' and your normal IDENTITY column

r937.com | rudy.ca

 

[alexanderthegreat]

Can I do that within the same table?

 

[r937]

yes, that's what a computed column is

see the CREATE TABLE syntax, and search on that page for computed_column_expression

r937.com | rudy.ca