SQL joining from list of values to match single value?

Kay C Lan lan.kc.macmail at gmail.com
Fri Sep 9 00:42:09 EDT 2016


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.




More information about the use-livecode mailing list