I have no idea if this will work/is possible, but could you put a trigger on the record so that when something is inserted, it replaces each field with ALLTRIM(fieldname)?

-Michelle


>I need to insert "CERT" into a field that is 10 characters long on a sysbase database engine. I can't allow spaces to pad out the field, or another application will refuse to see the record. This DOESN'T work:
>
>insert into master_cred (system_name) values ("CERT")
>
>That will pad with spaces. What do I need to do?
>
>Thanks! :-)