RE: Help with SQL syntax

["Bob Cozzi \(RPGIV\)" <cozzi@xxxxxxxxx>]

You can create a view with values in it, such as 'IBM' when Name like
'%IBM%', however you will most likely need to create a table and insert
values into that table with a subquery; one for each "company" name you
want to group by.

But what do I know, I'm an RPG programmer. <g>

Bob Cozzi
cozzi@rpgiv.com
Visit the on-line  Midrange  Developer  forum at: http://www.rpgiv.com


> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]
On
> Behalf Of Giri Gopal
> Sent: Thursday, January 10, 2002 10:49 AM
> To: rpg400-l@midrange.com
> 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.