jnsimex
asked on
Append prefix to OrderID upon insert of new record
Upon the insert of a new record, I need to append a two character prefix to the OrderID which is an identity value.
How would I accomplish with in SQL Server 2005 ?
How would I accomplish with in SQL Server 2005 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks guys!
The ID property must be a numeric value. You cannot modify the column to accept characters and maintain the IDENTITY property. The identity options are grayed out.