SQL joining from list of values to match single value?

[Mike Kerner]

If you really only have hundreds of records, and you aren't doing many
queries as part of the same operation, you have spent more time fighting
through this than you will save in the rest of your life running it.

On Fri, Sep 9, 2016 at 12:42 AM, Kay C Lan <lan.kc.macmail at gmail.com> wrote:

> On Fri, Sep 9, 2016 at 6:37 AM, Dr. Hawkins <dochawk at gmail.com> wrote:
> >
> > Do you include a delimiter after your first and last entries?  It seems
> > clumsy, but I don't see a way around it with LIKE
>
> WHERE dpdDnas LIKE '7,%' OR dpdDnas LIKE '%,7,%' OR dpdDnas LIKE '%,7'
>
> I've found that leaving the list as a 'natural' LC List creates less
> headaches down the track than the SQL triplicate OR statement.
>
> _______________________________________________
> 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
>



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."