I had a situation with thousands of electrical meters that took readings as a timestamp, and needed to pull the last reading for selected meters. The meter ID's were alphanumeric, and I used CONVERT() to return the timestamp as yyyy:mm:dd:hh:ss which worked, but I wouldn't venture to guess it was any more elegant or faster than your solution.

Stan