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