I should make some fields required length like filling blanks to the end of the field until it has 20 characters.
RPAD function works if field is not null but looks like RPAD don't add characters if the field is NULL.
My admin version is 6.3. Does RPAD work same way with 7.x versions?
Is there any easy way to handle this?