What do you expect to happen to your C2 if you overwrite it with C3?
Other than that, are you talking tables, variables or something else?
A little more information would be helpful.

Yeah, I need a lot more information to be able to help with this.

If these values are stored as text (A, B, C, C1, C2, C3, etc.), they should already sort alphanumerically just fine. If your goal is to easily move items up and down in the list with buttons, then I would recommend adding a separate numeric SortOrder field and sorting on that instead.

In fact, I just recorded a video on this exact topic. Take a look at Fitness 76 (coming out Monday, but you're a member so you can see it now), where I demonstrate how to add a custom sort field and move records up and down by changing their numeric sort values. It's much easier than trying to constantly renumber text-based codes.

Can you provide a little more detail about what these values represent and where they're stored?

Thomas I would hope that C2 moves to C3 while C3 becomes C2. The problem is that i have enter a string into and i would like the concept of say A, B, C, etc with index of A1, A2, A3 or B1, B2, B3 etc

Richard Thanks Richard, i just notice and watched

You could still do it numerically so that you can sort it properly and just have it so that A is 100, B is 200, C is 300, and so on, and then the tens and ones would indicate the number. So, for example:

- A1 would be 101
- A2 would be 102
- B1 would be 201
- and so on

All you'd have to do is divide by 100 to get the letter and then mod by 100 to get the numeric portion. That way you can sort them all numerically, still move them around, and then just display them with whatever you want to with the As and Bs and Cs and stuff. This would actually make a pretty cool video.