Kind of ugly as sin but
VALUES right('00000000' CONCAT trim(CAST(123 AS CHAR(8))),8)
VALUES
00000123


Rob Berendt




Return to Archive home page | Return to MIDRANGE.COM home page