Barcodes are stored in items.barcode as varchar type. Since our standard barcodes are numeric, is there a way to use arithmetic operators (<, >) on this column?
items.barcode >= 34258000220000 in a SQL report does not work, though items.barcode LIKE '3425800022%' does. Note that we may have the odd barcode which is not numeric. Cheers, Cab Vinton Sanbornton Public Library
_______________________________________________ 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/
