PADR(,200) always will return 200 characters string. The lenght of the string returned by SUBSTR() depends on its parameters. If you applay SUBSTR() to the memo field it could vary from record to record.
>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.
--sb--