If it did, we would have to rename the function :)
>Even more specifically, it doesn't pad result string to the lenght specified by its third parameter. :)
>
>>More specifically to what Sergey said, SUBSTR() does not increase the length of the string you pass to it.
>>
>>>BTW, I just needed to use that approach elsewhere I realized that only PADR() works. The SUBSTR() doesn't work. I've been trying to make SUBSTR() work by extracting the first 200 character. But, only PADR() at 200 character will work. I'm curious to know why SUBSTR() doesn't work.
Steve Gibson