[Koha-devel] Arithmetic operators on varchar column?

[Cab Vinton]

Just realized I hadn't responded ...

Thank you, Sophie. That does indeed work.

Galen's solution (explicitly casting the barcode as an integer) produces
the same results.

Thanks to both!

Cab Vinton
Sanbornton PL

On Wed, Apr 17, 2013 at 11:36 AM, Sophie Meynieux <
sophie.meynieux at biblibre.com> wrote:

>  Does items.barcode >= "34258000220000" answers your need ?
>
> Sophie
>
> --
> Responsable support
> BibLibre+ 33 (0)4 91 81 35 08http://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 listKoha-devel at lists.koha-community.orghttp://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 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/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20130423/82b41f1f/attachment-0001.html>