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?