what is the connection code you use??
[PHP]
Dim connectionStrin g As String = "server='YO UR SERVER'; trusted_connect ion=true; Database='YOUR DATABASE'"
Dim sqlConnection As System.Data.Sql Client.SqlConne ction = New System.Data.Sql Client.SqlConne ction(connectio nString)[/PHP]

I use this code to connect to SQL Server 2005

I came up with this:

[HTML]If Call1.Text <> "" Then
query1 = "([Call1] LIKE '%' + @Call1 + '%') "
End If
If Call2.Text <> "" Then
If query1 <> "" Then
query1 = "([Call2] LIKE '%' + @Call2 + '%')" & and1 & query1 & ""
Else
query1...

User can input text into one field, few or all of them.

I was reading about CASE statement and perticulary I found following code:

[HTML]
SELECT ckey, cnam, W.contractor_id , COUNT(*) AS tcnt,
COUNT(CASE WHEN rrstm=1 AND rcdt IS NULL THEN 1 END) AS r1,
COUNT(CASE WHEN rrstm=2 AND rcdt IS NULL THEN 1 END) AS r2,
COUNT(CASE WHEN rrstm=3 AND rcdt IS NULL THEN 1 END) AS r3,
COUNT(CASE...

I have SELECT query:

[HTML]SELECT * FROM [Table1] WHERE (([Call1] LIKE '%' + @Call1 + '%') AND ([Call2 LIKE '%' + @Call2 + '%')AND ([Call3] LIKE '%' + @Call3 + '%')AND ([Call4] LIKE '%' + @Call4 + '%')AND ([Call5] LIKE '%' + @Call5 + '%') AND ([Call6] LIKE '%' + @Call6 + '%')OR ([Call7] LIKE '%' + @Call7 + '%')OR ([Call8] LIKE '%' + @Call8 + '%') AND ([Call9] LIKE '%' + @Call9 + '%')AND ([Call10] LIKE '%' + @Call10 + '%')AND ([Call11]...