>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
¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø¤º°¤º°`°º¤ø¤º°¤º°
Carl Evans
CEO & President
System Answers Consulting, Inc.
MCSD .NET, ASP.NET, C#.NET, VB.NET,