dwain.c (9/9/2013)
PRINT '========== Another Integer Math Method =========='
SET STATISTICS TIME ON;
SELECT @Bitbucket = RIGHT(1000000000 + C1*1000 + C2, 9)
FROM #TestTable;
SET STATISTICS TIME OFF;
Oh, now that's just bloody clever. You stayed away from anything character based until "display time". Well done!
--Jeff Moden
Change is inevitable... Change for the better is not.