Hi Everyone

I am having a problem with an SQL statement into an SQL89 Progress database. I have 4 fields in the database itmg_nm,sub1,sub2,sub3 that work together in a hierarchy for example table

GNRL HIN BUT AAA
GNRL HIN CLA AAA
GNRL MOO BBB CCC
HAND SAW
HAND WIC JJJ
HAND WIC PPP

The lower levels (sub1,sub2,sub3) do not always have a value. I want a select statement that would select from the above example only following records

GNRL HIN CLA AAA
GNRL MOO BBB CCC
HAND SAW
HAND WIC JJJ

Because I'm using SQL89, I can't seem too use any concatenating functions in the select statement. Has any one any ideas how a select statement could be written to extract only this information.

Thanks
Darren