adding a concatenated field in an SQL query breaks LIKE

Peter Haworth pete at lcsql.com
Sun Jul 13 13:00:45 EDT 2014


Thanks, our posts crossed.

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

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

Pete
lcSQL Software <http://www.lcsql.com>
Home of lcStackBrowser <http://www.lcsql.com/lcstackbrowser.html> and
SQLiteAdmin <http://www.lcsql.com/sqliteadmin.html>


On Sun, Jul 13, 2014 at 8:34 AM, Dr. Hawkins <dochawk at gmail.com> wrote:

> On Sat, Jul 12, 2014 at 7:20 PM, Dr. Hawkins <dochawk at gmail.com> wrote:
>
> >
> > However, when I add one more concatenated field for the LIKE to search
> > through, I get the query (which seems correct)
> >
> > SELECT uniqDna, cname, cadr, reason, asset FROM vader_darth______001_dna
> > WHERE ((cadr NOT NULL) AND (chrType<>'K') AND ((cname ||cadr  || reason)
> > LIKE '%alde%'  )) ORDER BY cname ASC, cadr ASC;
> >
>
> This should have included (cname ||cadr  || reason || asset),  not just the
> first three.
>
> I've also found that
>
> (((cname ||cadr  || reason) LIKE '%alde%'  ) OR (asset LIKE '%aide$'))
>
> gives the result that I would expect from
>
>  ((cname ||cadr  || reason || asset) LIKE '%alde%'  )
>
> Is there some kind of concatenation limit, perhaps?
>
>
>
> --
> Dr. Richard E. Hawkins, Esq.
> (702) 508-8462
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the Use-livecode mailing list