>select T.F1, T.F2, T.F3, T.F4, T.F5 FROM ; >(select F1, F2, F3, F4, CAST(LEFT(F5,250) AS varchar(2500) as ShortF5 from Tab1 GROUP BY F1, F2, F3, F4, ShortF5) X ; >INNER JOIN Tab1 T ON T.F1 = X.F1 AND T.F2 = X.F2 AND T.F3 = X.F3 AND T.F4 = X.F4 AND T.F5 LIKE X.ShortF5+'%' ; >ORDER BY T.F1, T.F2, T.F3, T.F4>