>Sergey,
>
>Although you suggestion would work, I have found from my experiences that the format of the character field may not always be consistent with padding the zeros. By casting the character field to a numeric then I can be sure to always group as expected. If I was guaranteed the format would be consistent with the padding then your suggestion would be better for performance.
>

I can see where it could be usefull. Thanks.