T-SQL Format integer to 2-digit string August 3, 2023 by Tarik select right ('00'+ltrim(str( <number> )),2 )