> However, I would like to know whether there is any way to extract the > sub-title from the field marc using sql statement ?
Yes. See this example in the SQL reports library: https://wiki.koha-community.org/wiki/SQL_Reports_Library#Title.2FSubtitle_List -- Owen -- Web Developer Athens County Public Libraries http://www.myacpl.org _______________________________________________ Koha-devel mailing list Koha-devel@lists.koha-community.org http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/