Does items.barcode >= "34258000220000" answers your need ?
Sophie
--
Responsable support
BibLibre
+ 33 (0)4 91 81 35 08
http://www.biblibre.com
Le 17/04/2013 17:14, Cab Vinton a écrit :
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/
_______________________________________________
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/
