Viewing 4 posts - 1 through 4 (of 4 total)
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...
August 21, 2003 at 10:36 am
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...
August 21, 2003 at 10:12 am
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...
August 21, 2003 at 9:58 am
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...
August 21, 2003 at 9:40 am
Viewing 4 posts - 1 through 4 (of 4 total)