[Koha] more sql silliness

Erik Lewis elewis at ngrl.org
Fri Nov 6 09:10:31 NZDT 2009


It's VARCHAR, unfortunately that didn't work, but thanks for clueing  
me into what I see as a very useful function.

On Nov 5, 2009, at 3:06 PM, Greg Barniskis wrote:

> Erik Lewis wrote:
>> Actually tried it with the commas, same effect.
>
> I'd think isbn was a string, but if it's numeric you might need to
>
> 'string one', CAST(isbn AS CHAR), 'string three'
>
>
> -- 
> Greg Barniskis, Computer Systems Integrator
> South Central Library System (SCLS)
> Library Interchange Network (LINK)
> <gregb at scls.lib.wi.us>, (608) 266-6348



More information about the Koha mailing list