adding a concatenated field in an SQL query breaks LIKE

[Dr. Hawkins]

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