Home Forums SQL Server 7,2000 T-SQL How Do I Zero-Fill an Int when converted to Char? RE: How Do I Zero-Fill an Int when converted to Char?

  • March 24, 2004 at 5:10 am

    #500181

    CONVERT(char(5),@dt,120)+RIGHT('0'+DATENAME(ww,@dt),2)