on Mon Sep 17 10:59:49 CDT 2012, Klaus on-rev wrote: I am wondering if it is possible to search the complete table instead of a particular column. Know what I mean? Like this pseudocode: ... SELECT * FROM Persons WHERE ANY_COLUMN LIKE 'sa%' ... Thanks for any hints or workarounds if this is not possible ;-)
Klaus try concatenating the columns like this: SELECT Column1, Column2, Column3 FROM Table WHERE (Column1 + Column2 LIKE 'MyCriteria%') But the column data types must be the same for concatenation. Therefore CASTing column types into the same data type should work. Mark _______________________________________________ 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