Home Forums SQL Server 7,2000 T-SQL Pad varchar with leading zeros RE: Pad varchar with leading zeros

  • November 25, 2002 at 6:45 pm

    #442375

    Or

    REPLICATE('0', 5-LEN(field_name)) + field_name