Gossamer Forum
Home : Products : DBMan : Customization :

Sorting call numbers

Quote Reply
Sorting call numbers
I hope someone can help me with a sorting problem. My records have a call number field that contains both letters and numbers. I would like the letter part to sort alpha, and the number part to sort like whole numbers. Changing the field type doesn't make a difference. Some examples of the fields and how they should sort:

PVK 12

PVK 110

PVK 120

R 1

And so on... Thanks for any help.