Dear Koustubha, Magnu and Lenora, Thank you for the quick response. I understood from your mail that data in 650 stored in xml and we have to filter it from there. This thing also mentioned in SQL Library in Koha Wiki. According to the SQL Library following query will filter data from 650-a field in biblio number 24. SELECT ExtractValue((SELECT marcxml FROM biblioitems WHERE biblionumber=24), '//datafield[@tag="650"]/subfield[@code>="a"]') AS ITEM What are the changes in query list entire 650-a field from all records? -- Vimal Kumar V. Asst. Librarian Asian School of Business Technopark, Trivandrum-695 581 Web: www.vimalkumar.co.nr Blog: http://vimalkumar.oksociety.in OK Society Volunteer. http://oksociety.in --------------------------------------------------------------------------- "I forget what I was taught. I only remember what I have learnt" -Patrick White