Search whole table

[mrobinson]

i am needing to do a key word search throughout a whole table except the first column (there are 20 columns in all) Please could you tell me the simplist way of doing this.

Thanks

 

[r937]

simplest?

[tt]select col1, col2, col3, col4, col5
from yourtable
where col2 & col2 & col4 & col5
like '*foo*'[/tt]

probably not the most efficient, though

especially if there are non-character columns in the mix...


rudy

 

[mrobinson]

thanks, i forgot to mention that it will be searching the table for a user input from a combo box. Please help me with this, i've been trying to do this for weeks,

thanks

 

[r937]

sorry, i don't know what a combo box is, maybe somebody else can help

(this is the "access queries and jet sql" forum, and that's all i know about access)


rudy