Forum Moderators: open
i need to have an auto increment for a field where the field is a varchar i.e. i need something like
ABC0000234 to be incremented to ABC0000235 automatically on insert operation.
The best solution I can offer is to make it 2 fields- one that is VARCHAR and one that is INT that is auto incremented. Then setup a trigger to populate the VARCHAR field based on the value of the INT field.
You'll need some additional logic for what to do for the next record after ABC9999999. Maybe make the characters defendant on (INT field)/10000000?
