Wildcard Search - what's wrong?

[net123]

I am trying to do a wildcard search on my page with the following code:

Dim queryString As String = "SELECT [tblX].* FROM [tblX] WHERE ([tblX].[XYZ] like @Search)"
[/blue]
I have tried different variations of syntax, but I can't seem to get the "" in the right place.

 

[Isadore]

SELECT ContactName FROM tblContacts WHERE Last Like" & strSQL