I am trying to form the syntax to produce a new field with contents from portions of existing SQL 2000 fields. Here is what I have:
Existing fields - customer number (5 digits, varchar)
Old sequence number (7 digits, varchar - 1st 2 digits indicate year, i.e. 07, 08)
I need to produce a new field in the following format -
2 digit year '-' customer number '-' incremental count based upon customer number
Example - Customer 10081, year 07
Desired new sequence number outcome - 07-10081-1
Next sequence number for the same customer - 07-10081-2, etc
When the customer number changes, the incremental count resets to '1'.

Any help here??

Thanks in advance