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