Tuesday, August 23, 2011

Trim leading zeros

REPLACE(LTRIM(REPLACE([Column], '0', ' ')), ' ', '0')
Thanks, 

No comments: