>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

Jerry

You need to create a full-Text index on the myfield in order to qualify the field search CONTAINS.

Evans