Re: Help with SQL syntax

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

uh, not tested by try:

select ...
case
 when position('IBM' in name) <> 0 then 'Use me'
 when position('CISCO' in name) <> 0 then 'Use me'
 end case as useme
...

where useme = 'Use me'


or something like it.....

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - iSeries Administrator
 -- IBM Certified Specialist - RPG IV Developer

"I want to be different, just like everybody else!"
  - Ceili Rain

----- Original Message -----
From: "Giri Gopal" <GiriGopal@bcginK.com>
To: <rpg400-l@midrange.com>
Sent: Thursday, January 10, 2002 11:48 AM
Subject: Help with SQL syntax


> Hello:
>
> I have a  table with name,amount, city & state fields, which users have
> keyed in different info in the name field, city and state are unique.
>
>  Example: for Customer = IBM:
>  The data in the name fields are:
> IBM @ Newyork connection
> Chicago IBM center abc
> SF IBM 11245
>
>  City and State fields: New York, NY
>
> I need to   group all the customers where name in %IBM%, %CISCO% etc and
sum
> the amount fields. How can I do this if the name fields are varying as
> stated above.
>
> Isn't there a way I can change the values of the name field such as: if
> %IBM% change the values of the name field to IBM and so on.
>
> Thanks for your help in advance.
> GG
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>