adding a concatenated field in an SQL query breaks LIKE

Dr. Hawkins dochawk at gmail.com
Sun Jul 13 15:05:15 EDT 2014


On Sun, Jul 13, 2014 at 10:00 AM, Peter Haworth <pete at lcsql.com> wrote:

> Still confused though.  There is no "$" wildcard available for the LIKE
> operator, only "%" and "_"
>


That came from typing rather than pasting that line :)  The code that works
has a %



> One other possibility.  It seems the LIKE operator has problems with
> non-ASCII characters - any chance asset includes some, perhaps accented
> characters?
>

That *shouldn't* be possible.  And if so, I need a filter to prevent that
from happening . . .

However, given that the match works when breaking of the asset column to an
OR, I doubt that reason, as it should bite there, too.  (Hmm, or should
it?  maybe not.)


-- 
Dr. Richard E. Hawkins, Esq.
(702) 508-8462



More information about the use-livecode mailing list