question o sql 2005
Database
2
Posts
2
Posters
0
Views
1
Watching
-
Actually i want some character before the digits.so it should looklike RXY1234. because the company ID should not be only 1,2..like this.
p.sethi
hi. U will again have to use a trigger. but not the autoincrement features. maintain a count of the company ids. u can use string concatenation to insert "RXY" + the company id count, while inserting the string in the company id column.
Keshav Kamat :) India