Viewing 2 posts - 1 through 2 (of 2 total)
Wouldn't let me edit:
UPDATE TABLE1 SET Field1 = REPLLICATE(' ', 7-LEN(LTRIM(RTRIM(Field1)))) + LTRIM(RTRIM(Field1))
September 10, 2004 at 7:06 am
#522531
UPDATE TABLE1 SET Field1 = REPLLICATE('', 7-LEN(LTRIM(RTRIM(Field1)))) + LTRIM(RTRIM(Field1))
September 10, 2004 at 7:02 am
#522529