Search Tool

I have a typed dataset where I used the sql query builder to build the following:

SELECT     DealManager.*, Contact AS Expr1
FROM         DealManager
WHERE     (Contact = @Contact)

How can I incorporate the "where % % " clause into this statement and still except the required parameter. In other words, I want something like this:

SELECT     DealManager.*, Contact AS Expr1
FROM         DealManager
WHERE     (Contact like %@Contact%)

but I get an error when I compile this...

Any help always appreciated!!!