IIS Index Server - Finding MUltiple Filenames with #filename

Author

Finding MUltiple Filenames with #filename

bstover@norcalmutual.com

2005-04-06, 5:57 pm

This is what I would like to achieve:

I want to search for all filesnames that begin with ABC AND all files
that begin with DEF. I want both filenames to be returned in the
query.

#filename=abc* AND #filename=def*

How to I contruct a query to do this?

neilx

2005-04-08, 7:49 am

bstover@norcalmutual.com wrote:
> This is what I would like to achieve:
>
> I want to search for all filesnames that begin with ABC AND all files
> that begin with DEF. I want both filenames to be returned in the
> query.
>
> #filename=abc* AND #filename=def*
>
> How to I contruct a query to do this?

WHERE Filename LIKE 'abc%' OR Filename LIKE 'def%'