Search By File Name

Hi,

I want to be able to search by a part of a file name, for example, if I have
a file named "THIS_IS_A_TEST.doc", I want to be able to find it by entering
"this" in the search box.

My query is like this:

SELECT Title, Rank, Size, Description, Write, Path, PictureURL FROM SCOPE()
WHERE FREETEXT(DefaultProperties, '" + search + "') OR CONTAINS(Path, '" +
search + "') OR CONTAINS(Description, '" + search + "') OR CONTAINS(Title, '"
+ search + "') ORDER BY Rank DESC

Any clues?

Thanks in advance!

Ricardo Peres