Re: Mutiple Filename Queries using #filename

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "neilx" <neil@xxxxxx>
Date: 6 Apr 2005 22:36:59 -0700

bstover@xxxxxxxxxxxxxxxx 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%'

.

References:
- Mutiple Filename Queries using #filename
  - From: bstover
- Re: Mutiple Filename Queries using #filename
  - From: David Lee
- Re: Mutiple Filename Queries using #filename
  - From: Stu
- Re: Mutiple Filename Queries using #filename
  - From: bstover

Prev by Date: Re: iisample - query.htm - 404 - File or directory not found.
Next by Date: Re: single characters
Previous by thread: Re: Mutiple Filename Queries using #filename
Next by thread: Characterization return empty value.
Index(es):
- Date
- Thread

Relevant Pages

Finding MUltiple Filenames with #filename
... I want to search for all filesnames that begin with ABC AND all files ... that begin with DEF. ... How to I contruct a query to do this? ...
(microsoft.public.inetserver.indexserver)
Re: Finding MUltiple Filenames with #filename
... > I want to search for all filesnames that begin with ABC AND all files ... > How to I contruct a query to do this? ... WHERE Filename LIKE 'abc%' OR Filename LIKE 'def%' ...
(microsoft.public.inetserver.indexserver)
Trying to understand Group By
... filename, filedate, origin ... filedate is the respective date stamp ... My query takes the max of filedate, ... eliminate all of the other records that have multiple filedate records ...
(comp.databases.ms-access)
Help, please. Unneeded variable replacement verbiage spooled to output file.
... I have created a query file that I run from a batch that calls ... column filename_column new_value filename ... column backday_column new_value backday ... spool &filename ...
(comp.databases.oracle.server)
Re: Help, please. Unneeded variable replacement verbiage spooled to output file.
... I have created a query file that I run from a batch that calls ... column filename_column new_value filename ... column backday_column new_value backday ... spool &filename ...
(comp.databases.oracle.server)