<div dir="ltr">Just realized I hadn't responded ...<div><br><div>Thank you, Sophie. That does indeed work.</div></div><div><br></div><div style>Galen's solution (explicitly casting the barcode as an integer) produces the same results.</div>
<div class="gmail_extra"><br clear="all"><div>Thanks to both!<br><br>Cab Vinton<br></div>
Sanbornton PL<br><br><div class="gmail_quote">On Wed, Apr 17, 2013 at 11:36 AM, Sophie Meynieux <span dir="ltr"><<a href="mailto:sophie.meynieux@biblibre.com" target="_blank">sophie.meynieux@biblibre.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div text="#000000" bgcolor="#FFFFFF">
<div>Does items.barcode >=
"34258000220000" answers your need ?<br>
<br>
Sophie<br>
<pre cols="72">--
Responsable support
BibLibre
<a href="tel:%2B%2033%20%280%294%2091%2081%2035%2008" value="+33491813508" target="_blank">+ 33 (0)4 91 81 35 08</a>
<a href="http://www.biblibre.com" target="_blank">http://www.biblibre.com</a></pre>
Le 17/04/2013 17:14, Cab Vinton a écrit :<br>
</div>
<blockquote type="cite"><div><div class="h5">
<div dir="ltr">
<div>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?</div>
<div><br>
</div>
<div>
<span style="line-height:13.63636302947998px;font-size:12.727272033691406px;font-family:arial,verdana,helvetica,sans-serif">items.barcode
>= 34258000220000 in a SQL report does not work, though
items.</span><span style="line-height:13.63636302947998px;font-size:12.727272033691406px;font-family:arial,verdana,helvetica,sans-serif">barcode
LIKE '3425800022%' does.</span><br>
</div>
<div><br>
</div>
<div>Note that we may have the odd barcode which is not
numeric.</div>
<br clear="all">
<div>Cheers,<br>
<br>
Cab Vinton<br>
</div>
<div>Sanbornton Public Library</div>
<div><br>
</div>
</div>
<br>
<fieldset></fieldset>
<br>
</div></div><pre>_______________________________________________
Koha-devel mailing list
<a href="mailto:Koha-devel@lists.koha-community.org" target="_blank">Koha-devel@lists.koha-community.org</a>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a>
website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a>
git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a>
bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a></pre>
</blockquote>
<br>
</div>
<br>_______________________________________________<br>
Koha-devel mailing list<br>
<a href="mailto:Koha-devel@lists.koha-community.org">Koha-devel@lists.koha-community.org</a><br>
<a href="http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel" target="_blank">http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel</a><br>
website : <a href="http://www.koha-community.org/" target="_blank">http://www.koha-community.org/</a><br>
git : <a href="http://git.koha-community.org/" target="_blank">http://git.koha-community.org/</a><br>
bugs : <a href="http://bugs.koha-community.org/" target="_blank">http://bugs.koha-community.org/</a><br></blockquote></div><br></div></div>