Search Multiple Parameters In Multiple Tables

Hi,

I am trying to build search engin with 11 parameters in 4 different tables in the database.

For example:

In search.aspx I have 11 textboxes namely

nameTextbox, phoneTextbox, nationalityTextbox, ageTextbox etc.

And in the result.aspx page I have gridview which post data from the database if the search match.

I wrote this stored procedure. P.S please ignore the syntax.

  @name var(30),

@nationality (30),

@phone int,

etc

as



Select a.UserId, b.UserId, c.UserId FROM Table1 a, Table2 b, Table3 c

WHERE

name LIKE '%' @name '%'

OR nationality LIKE '%' @nationality '%'

OR phone LIKE '%' @phone '%'

etc
 

But I got an error when I am trying to execute this code because the nulls values so I wrote

 1 @name var(30),
2
3 @nationality (30),
4
5 @phone int,
6
7 etc
8
9 as
10
11
12
13 Select a.UserId, b.UserId, c.UserId FROM Table1 a, Table2 b, Table3 c
14
15 WHERE
16
17 name LIKE '%' ISNULL(@name, '') '%'
18
19 OR nationality LIKE '%' ISNULL(@nationality,'') '%'
20
21 OR phone LIKE '%' ISNULL(@phone,'') '%'
22
23 etc
24
25


 

Also the error still exist.

What is the best way to search for multiple parameters in multiple tables ?

 

Thanks in advanced