Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
The exact phrase needs to be found
Message
 
 
To
17/12/2010 15:17:06
General information
Forum:
Level Extreme
Category:
Other
Miscellaneous
Thread ID:
01385793
Message ID:
01493158
Views:
70
>>If you get the dataset, can you apply the extra condition in .NET side? Although you can also do it in SQL.
>>
>>And may be you can apply LINQ on the result set.
>
>This was my main concern. This full text syntax is not a regular SQL syntax. So, it would have to be processed in a second level. But, I am not sure if this could work. Because, the omitted word can be everywhere and might not be found as is in the first result.

I don't see the problem. You can put your original query into temp table.
Say,
select *  into #Result from Threads where contains(Threads.Notes,"my current phrase")

if @ExactPhrase
   select * from #Result where Notes like '%' + 'My current phrase' + '%'
else
  select * from #Result
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform