select *, itmg_nm + sub1 + sub2 + sub3 as concatkey from table1 having concatkey >= 'GNRLHINCLAAAA' AND concatkey <= 'HANDWICJJJ'>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