SELECT Name from Table where upper(name) Like '%OPEN%'
UNION
SELECT Name from Table where upper(name) Like '%ENGG%'
UNION
SELECT Name from Table where upper(name) Like '%GOV%'
Not sure if that's what you want to achieve
-----Original Message-----
From: Jeff Small [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 09, 2004 8:50 AM
To: SQL
Subject: Fw: SQL Help
----- Original Message -----
From: "Jeff Small" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, March 09, 2004 11:47 AM
Subject: Re: SQL Help
> Hi Rodney, I'm not really able to help all that much, but what I suggest
is
> trying the SQL mailing list. I replied and forwarded this to that list in
an
> effort to get it over to "the SQL people". They're really great at this
sort
> of stuff, and you might get a faster, better response from it.
>
> Have at it, "SQL people".
>
>
> ----- Original Message -----
> From: "Bruce, Rodney S HQISEC/Veridian IT Services"
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Subject: SQL Help
>
>
> > Hi all
> >
> > I need some help with a query that supplies a report.
> >
> > The issue for me is one of the tables: (simplified)
> >
> > Table
> > UID Name Description Parent Project_id
> >
> >
> > This table contains different information in the same field (name),like
> the
> > projects status (Initializing, Engineering, etc) , the type of project
> > (Contractor, Govt), and condition (Open, Closed).
> >
> > So projects can have 1, 2 or 3 records in this table.
> >
> > The problem is if the user wants a report of all Open-Engineering-Govt
> > projects.
> >
> > Name is a Text field.
> >
> > So I can get all the open with:
> >
> > WHERE name LIKE '%Open%'
> > (needs to be LIKE because the information is not consistant, ie: Open,
is
> > Open, Opened, etc).
> >
> > But
> >
> > WHERE name LIKE '%Open%' and name LIKE '%Engineering%'
> > gets me nothing becuase the field cant be both at same time
> >
> > and
> > WHERE name LIKE '%Open%' or name LIKE '%Engineering%'
> > gets me projects that are closed as well as open
> >
> > I can get the information I need by running mulitple queries:
> >
> > <CFQUERY name="first">
> > WHERE name LIKE '%Open%'
> > </CFQUERY>
> >
> > <CFOUTPUT query="first">
> > <CFQUERY name="second">
> > WHERE name LIKE '%Engineering%' and project_ID =
> > #first.project_id#
> > </CFQUERY>
> > <CFIF second.recordcount GT 0>
> > is both opened and Engineering.
> > </CFIF>
> > </CFOUTPUT>
> >
> > But this is cumbersome.
> >
> > anyone know a better way?
> >
> > We are using: CF5 and SQL 2000.
> >
> > Thanks
> > Rodney
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
