I wrote a function that did that. You pass it a comma del list of column names, and it builds an sql statement for you. I will try to dig that up somewhere.
Bob On Sep 19, 2012, at 9:21 AM, Peter Haworth wrote: > I implemented exactly the same functionality in a name/address search db > once and ended up biting the bullet and using a WHERE clauses that tested > every column in the table for the string I was looking for. A pain to code > because I probably had 20 or 30 columns to search but sometimes the > simplest solution is the best :-) _______________________________________________ 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