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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only