Index On Chr Field which acts as if field was integer
In Chr fields we often have a mix of string and integer values which when indexed appear as 1,10,100,11,110,12,120. It would be good to have an index which was smart and detected when the value was an integer to make the sequence 1,2,3 etc. whilst still being able to hange characters.
Suggestion added by Philip L jackson - initial log in failed