SQL question

[Bob Sneidar]

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 :-)