1) Assuming that you have the source and destination defined and that the destination column is an 11 digit field packed with leading zeros

2) Create the transformation

3) Get all of...

Good suggestion from _brokenrulz_, but be aware that a group by on a date field will work well if your field is populated just to the date ('2003-08-21 00:00:00.00'), but...

It's been a while, but I know I've done it. I think that I've used two methods:

1) Copy paste into another program (but I don't remember what it was...

You say that you need to SORT and that the original values are CHAR. Assuming that the first four digits are year and that those after the hypen are...