Punctuation ?

Hi


I have this simple and working well SQL-row:





MyCommand = New SqlDataAdapter("SELECT * From Tbl_Table where Type = '" & TestType.tostring & "' ", MyConnection)





-----------


Then I have this one which I am very proud of because I can retrieve any word or part of word from the Item-field:





Test_Text=(Session("session-Text").tostring)





Dim val1, val2, val3 as string


val1 = Test_Text


val2 = "%"


val3= val1 + val2





MyCommand = New SqlDataAdapter("SELECT * From Tbl_Table where Item Like '%" & val1 & " %' OR Item Like '%" & val3 & " %' ", MyConnection)





------------


The problem is:


When I try to merge these two in one big "AND" row as shown below, It only cares of picking up the Test_Text string and ignores totaly the TestType one!


I guess it is a matter of punctuation, can any one help me? Thanks.








MyCommand = New SqlDataAdapter("SELECT * From Tbl_Table where Type = '" & TestType.tostring & "' AND Item Like '%" & val1 & " %' OR Item Like '%" & val3 & " %'", MyConnection)