>>And how you could recognize what are you searching if you pass just a list?
>>Are '12345678, 555577777' ZIP codes or phones or both?
>>Why not build the whole SELECT at your front end with proper WHERE clause and the send it to SQL Server?
>>You know where the user enters the search word and know what type is it, ZIP, Phone, Address1 or 2, names
>>
>>But use parameters:
>>

>>lcSELECT = [SELECT .... FROM People WHERE ]
>>** Now because you know WHAT user wants
>>lcSELECT = lcSELECT + [ Zip = ?Par1]
>>etc.
>>

>
>There is only one search textbox and the user may type anything he/she desires. Pretty much the same as here.

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