>>Thanks, Sergey. I'm going to use ADO. When I do a seria of selects in SQL Server, should it be written as SP?
>>My first select should return matching records ID and the next select will return the actual result. So, where should I put the first select?
>
>First, there's no such word as "seria". <eg>

What's the right term? Sequence?

>Second, I would use sproc's regardless if it's one select or T-SQL batch for reasons of performance and security.
>Third, the only way to use result of separate query from another is to create a temp. table. It's not recomended for performance reason. Instead you can use result of the first query as derived table in the second query which makes it a one select.

Thanks again. Looks like my data model is not going to work then. I was thinking about having one table with Address Info for all records, one table with all names and two tables with specific category related fields. However, I don't see a simple way of producing the result... (if all 3 categories will be checked).