Curious...
Don't you mean PADL(GetDocNo(),6,'0')?

>Hi - I am trying to create incrementing document numbers in the form "DOC000001". I have a stored procedure (GetDocNo) that takes care of generating the value which it returns as a string. I have a character field 9 wide and in the default I have
>"DOC" + PADR(GetDocNo(),6,"0")
>If I run this in the command window its Ok but the field gets "DOC 1" - if I increase the field length to 40+ I get "DOC00 1"
>
>Any ideas?