David

The fields are used as a drill down of product groups, so what I want the sql statement is to extract all records between (itmgnm='GNRL', sub1='HIN',sub2='CLA', sub3='AAA') and (itmg_nm='HAND', sub1='HIC', sub2='JJJ"). It's hard to explain, but if I was allowed to concatenate the 4 fields together, it would be easy. It would be like

select itmg_nm,sub1,sub2,sub3 from table1 where;
(itmg_nm_sub1+sub2+sub3)>="GNRLHINCLAAAA" AND ;
(itmg_nm+sub1+sub2_sub3)<="HANDHICJJJ"

But the SQL89 driver I'm using to access the Progress db doesn't allow me to concatenate the fields.

I hope this is clearer.

Thanks
Darren