>SELECT cast(g1csf.pacid /10000000 as int) as UREG, g1csf.* >into ProgeddTests > FROM g1csf INNER JOIN g1_cnsin > ON G1csf.cnsinv = G1_cnsin.cnsinv > where substring(ltrim(str(g1csf.pacid,14)),8,2) ='20' >and substring(ltrim(str(g1csf.pacid,14)),1,2) ='26' >having cast(g1csf.pacid /10000000 as int) >= 26000>HTH.