On Fri, Sep 9, 2016 at 6:37 AM, Dr. Hawkins <doch...@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode