Could 'Match' & 'March' be searched using wildcard character as "Ma*ch" or "Ma?ch" in

[Robin Jain]

I want wildcard character to search Match & March at the same time in indexing service. I am trying it with following query:

Select DocTitle,Filename,Size,PATH,URL,Directory from Scope() WHERE CONTAINS('"Ma*ch"')

Or

Select DocTitle,Filename,Size,PATH,URL,Directory from Scope() WHERE CONTAINS('"Ma?ch"')

But I am not getting any response as I think it tries to find Ma*ch as the complete word.

When I use * at the end of any prefix then it works fine, but I need it in middle of a word.
"Search is being done through documents not from database."

[GaryTexmo]

Honestly, I don't know LINQ very well so hopefully one of the other experts can weigh in on this one. For myself, I'll just ask you a few questions which will maybe lead you to the answer, or at least clarify to me what your code is doing.

The code you wrote is basically...

Select <fields> from <object> where <condition>

... this seems fairly straightforward to me and I assume they are properties on a Scope object; however, I have two questions...

1) You are selecting from Scope()... does that automatically know enough to instantiate a new object? I would have expected you to need "new Scope()" or an object of type Scope there. Or is that a method that returns an object structure that the fields are a part of?

2) Your condition says "WHERE CONTAINS("Ma?ch")" but it doesn't specify what should contain that text. If it were SQL, you would write "where <field> contains 'Ma?ch'" but in your example you don't specify a field.

Could either of those have something to do with it?