>>yes, but you could search only by ONE type, try with: Boris MicroComplex and you will get no result.
>>So you have ONE parameter to pass to you SP :-)
>>And Michel as far as I know use Full-Text search :-)
>
>But you're right, I tried to search here and did receive 0 results. So, Michel's logic is different.
My point was: If you have only ONE textBox to enter values you should search for only ONE word, not list of words, no matter in which field is that word.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.