Correction, The last line should be as follows:

1 joe smith 123 test part
2 bill white 111 partb
3 dave green 123 test part

Thanks for your reply. There are no dates in the table. The table definition is as follows:

CREATE TABLE FGTAB.Product_Info
(
Emp_nr NUMBER,
Last_name VARCHAR2(50),
First_name VARCHAR2(50),
Prod_cd VARCHAR2(16),
Prod_descr VARCHAR(100),
Misc_notes VARCHAR(100)
)

There are no keys in the table. The table holds about 200 entries.

Thanks again for your help.