[Koha-devel] Arithmetic operators on varchar column?

[Cab Vinton]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130417/8ea02c26/attachment.html>