SQL joining from list of values to match single value?

[Kay C Lan]

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.