Hi
Would something like
Select * from table where trim(item) = '256'
?
Cheers,
Martin
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Dave Petrosky
Sent: 14 June 2010 14:00
To: rpg400-l@xxxxxxxxxxxx
Subject: SQL looking for differences in rows in same table
I have a table where my data would be like
Company Warehouse Item Vendor
1 1 256 25
2 1 256 *blanks
3 1 256 24
4 1 256 24
1 1 303 25
2 1 303 25
What I am looking to do is generate a list which will show all of the
Item 256 rows (since these rows are not all the same) but not show any
of the Item 303 rows.
David M. Petrosky
Programmer/Analyst
Maines Paper & Food Service, Inc.
101 Broome Corporate Parkway
Conklin, NY 13748
(office) 607-251-7378
dave.petrosky@xxxxxxxxxx
www.maines.net <
http://www.maines.net/>
--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing
list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
--------------------------------------------------------
This message (including any attachments) is only for the use of the person(s) for whom it is intended. It may contain Mattel confidential and/or trade secret information. If you are not the intended recipient, you should not copy, distribute or use this information for any purpose, and you should delete this message and inform the sender immediately.
Mattel UK Limited is incorporated in England and Wales with its registered office at Mattel House, Vanwall Business Park, Vanwall Road, Maidenhead, Berkshire SL6 4UB. Company Registration Number 1471442.
midrange.com
