On 15 December 2011 14:39, Elaine Bradtke <eb@efdss.org> wrote:

Nope, that didn't work.  How about something that will give me the biblio number and the contents of the associated 942$c? I can sort those in a spreadsheet and it might also give me a clue as to what's going on. Elaine

What didn't work about it? You got no results? or not the right amount? SELECT biblionumber, ExtractValue(marcxml, '//datafield[@tag="942"]/subfield[@code="c"]') AS comp FROM biblioitems Will give you biblionumber and the contents of 942c .. again only if your mysql server its 5.1.5 or greater Chris