>So I would change my insert statement to something like:
>
>insert into master_cred (system_name) values ("CERT"+.null.)
>
>Would that work? Is there a way to do that for every field in the system automatically? I would rather not have to set it up for every field (there are a few hundred of them in the final insert statement.)
What you want to do is put an insert trigger on the SQL Server database to trim the fields when it receives them. You should be able to optimize that by creating a stored procedure to do it (on SQL Server) and having the insert trigger call the stored procedure for each field needed. I'm assuming you have authority to do this sort of thing on the server side??? If not, you may be able to create a remote view and *possibly* do something similar on the client side??