• Wayne, yes, thank you. That explains it completely. So, using your example of a time "80101", the code would (working from the inside out) transform it thusly:

    80101 (original)

    10108 (reversed)

    10:108 (stuff 3rd position with colon)

    10:10:8 (stuff 6th position with colon)

    8:01:01 (re-reverse)

    So, all that remains to be explained is...are you guys some kind of freaking sql wizards or what? What hope is there for us normal people with you lot lurking around? 🙂

    Thanks, I continue to be in awe at the creativity, intelligence, and amazing patience and tutelage available on this site.

    EDIT: P.S. Your double-stuffed remix is tasty too!


    "If I had been drinking out of that toilet, I might have been killed." -Ace Ventura