I'm thinking this may not give you the same results as checking each column individually. Is the need to check for the same value in each column or for a different value in each column?
Pete lcSQL Software <http://www.lcsql.com> On Mon, Jul 15, 2013 at 6:39 AM, Klaus major-k <kl...@major-k.de> wrote: > > Am 15.07.2013 um 15:59 schrieb j...@splash21.com: > > > Googling it suggests that '||' is concatenate in SQLite, so try; > > > > WHERE (name || tags || comment) LIKE '%..... > > Wonderful, will try this! > Thanks a bunch! > > > Best > > Klaus > > -- > Klaus Major > http://www.major-k.de > kl...@major-k.de > > > _______________________________________________ > 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 > _______________________________________________ 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
