>*-- Updated/not totally awake on first version... >select ; > cast( IIF(Len(Alltrim(MemoFld))/50>30, 30, ; > Len(Alltrim(MemoFld))/50 ) as I) as LenMemo ; > , count(*) as CntMemo ; > from Table ; > group by 1>
0 22279 1 42878 2 55157 3 62078 4 66254 5 67012 6 65358 7 62342 8 59053 9 54701 10 50604 11 46451 12 42527 13 38950 14 35041 15 32001 16 29263 17 26161 18 24143 19 21734 20 19734 21 17665 22 16405 23 14641 24 13306 25 12317 26 11079 27 10382 28 9138 29 8642 30 118375Thread.cdx 48,317 KB