Library call numbers

[timbits35]

Hi,

I would like some advice for fields for call numbers for a library database that I have at work.

Right now the call numbers are structured as per below. The letters representing the category abbreviation and the numbers a sequential number. Except when it comes to journal articles which I also show the numbering. The journals are numbered as such because each journal may have several volumes and within each journal there are several articles. Right now this is 1 field called Call number. I do have separate fiels for volume, but I need to put a sticker on the book or journal itself.

A/M 1
A/M 2
ADR 1
ADR 2
ADR 2a
SL 1
SL 2
J 1
J 1.1.a
J. 1.1.b

As you may imagine, this makes sorting by call number impossible as the call number is text. I have thought about making 2 fields, 1 for call letters and 1 for call numbers, but the call numbers are text as well (1.1.a).

Any advice on how to choose call numbers?

 

[Pat Hartman]

The only way to sort multi-field text strings is by separating out the strings. When you mush them together, your sorts will not be what you expect logically. I see four parts to J. 1.1.b - Are there more?

 

[timbits35]

Hi,

I have solved part of the problem by padding the field with an extra 0's and this has helped the sort of part of it at least. So now at least

A/M 001
A/M 010
ADR 001
ADR 010

now sort properly.

I am not sure about the J.1.1 and J.10.a etc.

Thank you,
Liane