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.macm...@gmail.com<mailto:lan.kc.macm...@gmail.com>> wrote: WHERE dpdDnas LIKE '7,%' OR dpdDnas LIKE '%,7,%' OR dpdDnas LIKE '%,7' _______________________________________________ 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
