>?LEN(PADL('FRED',13,' ')) returns 13 as you'd expect
>
>but
>
>?PADL('FRED',13,' ')+'BLOGGS' returns "FREDBLOGGS" instead of "FRED BLOGGS" which is what I want.
>
>why?
>
>and how do I get what I want?
>
>Thanks
>
>Harry


If you are looking for a 13-character result *after* adding the two fields together, than you should be using ...

? PADR('FRED' + ' ' + 'BLOGGS', 13) && For Left-Justified
? PADL('FRED' + ' ' + 'BLOGGS', 13) && For Right-Justified

If you are using variables instead of hard-coded names, than change the code to ...

? PADR(ALLTRIM(cFirstName) + ' ' + ALLTRIM(cLastName), 13) && For Left-Justified
? PADL(ALLTRIM(cFirstName) + ' ' + ALLTRIM(cLastName), 13) && For Right-Justified

Cathy