Tuesday, December 22, 2015

MCU/HMCU right justify JD edwards

update F0006dataload set mcmcu=right(replicate(' ',8)+ cast(ltrim(rtrim([mcmcu])) as varchar),12)

No comments: