support for like expression

Nov 6, 2009 at 9:20 AM

I try to modify this webpart a bit because the contains() method does not to support searching for a part of a word like: *ildcar* does not find anything but wildcar* is working like it should

So I tried to add a like statement, your webpart creates this query:

SELECT WorkId, Rank, Title, Author, Size, Path, Description, Write, SiteName, CollapsingStatus, HitHighlightedSummary, HitHighlightedProperties, ContentClass, IsDocument, PictureThumbnailURL FROM Scope() WHERE Title LIKE '%ildcar%' OR Description LIKE '%ildcar%' OR HitHighlightedSummary LIKE '%ildcar%'

and....? Nothing found.

The title should be correct at least.

Coordinator
Nov 12, 2009 at 2:52 PM

Your query looks correct.  Not sure why that wouldn't be working for you.