SQL joining from list of values to match single value?

[Bob Sneidar]

I got around the need for or-liking (I just made that up) by making sure the first (and last??) item of a list was blank. Ex. "|14|28|763|" If you do this, you can always look for LIKE '%|763|&'. Of course we know that to Livecode, a trailing delimiter does NOT mean the last item is blank, but Sequel doesn't know that!

Bob S

On Sep 8, 2016, at 21:42 , Kay C Lan <lan.kc.macmail at gmail.com<mailto:lan.kc.macmail at gmail.com>> wrote:

WHERE dpdDnas LIKE '7,%' OR dpdDnas LIKE '%,7,%' OR dpdDnas LIKE '%,7'