Darren,

Can you better explain what qualifies only those rows to be selected, or what disqualifies the rows you don't want selected? How abot posting the SQL command you are trying to use?

>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.