Home Forums Data Warehousing Integration Services SSIS Package to remove leading 0's RE: SSIS Package to remove leading 0's

  • May 22, 2013 at 8:02 am

    #1617447

    REPLACE(LTRIM(REPLACE(field,"0"," "))," ","0") is the expression, this won't work if field value has space characters