General information
Category:
Coding, syntax & commands
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only