17 Apr
2013
17 Apr
'13
4:14 p.m.
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