Darren,

The SQL is one thing, but can you give us in words what you are trying to accomplish so we can figure out why the sql doesn't do what you want?

>Here is the sql statement

select itmg_nm,sub1,sub2,sub3 
   from table1 
   where ((itmg_nm > = "GNRL") and not; 
      (itmg_nm="GNRL" and sub1 < "HIN") and not (itmg_nm="GNRL" and sub1="HIN" and; 
   sub2 < "CLA") and not (itmg_nm="GNRL" and sub1="HIN" and sub2="CLA" and sub3 < "AAA")) and ((itmg_nm < = "HAND") and not (itmg_nm="HAND" and sub1 > "WIC") and;
  not (itmg_nm="HAND" and sub1="WIC" and sub2 > "JJJ"))

>Is there an easier way to do this? Any help appreciated.