I think you need a separate sort field where you give each code section the
maximum space the code section can take, then sort on this

e.g. AM7--.G55--2004-----, where - is a space

all codes need to be the same length for sorting to work correctly


"clemcorc" wrote:

I'm trying to sort a list of call numbers for a library and I want the list
to read as follows:
AM7 .G55 1996
AM7 .R435 2004
AM11 .G45 1994
AM101 .S55 S555 1993

But when I sort, it looks like this:
AM101 .S55 S555 1993
AM11 .G45 1994
AM7 .G55 1996
AM7 .R435 2004

Any suggestions?