I'm not sure that will work. If Column2 started with "MyCriteria", I don't think it would be selected. Any queries of the form LIKE '%mycriteria%' would work though.
Klaus, have you implemented a solution to this yet? I don't recall you mentioning which flavor of SQL you're using and that makes a difference. Pete lcSQL Software <http://www.lcsql.com> On Tue, Sep 18, 2012 at 8:13 PM, Mark Stuart <mfstu...@cox.net> wrote: > Klaus try concatenating the columns like this: > SELECT Column1, Column2, Column3 FROM Table WHERE (Column1 + Column2 LIKE > 'MyCriteria%') > _______________________________________________ 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
