Using VS2005. Is it possible to use the SQL Server Contains() function in the TableAdapter Query Configuration Wizard? If so how can I do this?

Here is what I have been trying in the wizard:
SELECT * FROM mytable WHERE contains(myfield, @myvar)

But the wizard tells me that the keyword @myvar SQL construct or statement is not supported.

Any ideas?

Thanks,

Jerry