[Koha-devel] Arithmetic operators on varchar column?

[Sophie Meynieux]

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 at 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/

-------------- section suivante --------------
Une pi�ce jointe HTML a �t� nettoy�e...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130417/4572e1be/attachment.html>