indexing service search with wildcard

[matej]

Hi all,
I'm having a strange problem preforming a search with my indexing service. Everything works fine, the problem are only the queries - it doesn't seem to like searches that are not exact words. For example, if I search for "dog" it will result all pages that containg the word "dog", but if I search for "dog*" it will not return all pages containing dogville, doggie, etc. but instead "no results".
Any ideas what could be the problem? I know this can be done, since I've seen it in the search part of a few iis sites and it is one of the features of the index server...

Thanks, matej

[Xoc]

You must use a "like" search to use wildcards. E.g. select * from whatever where foo like "dog*"