>>What do you mean by Varchar() data is trimmed? Do I need to trim the data before I insert it in the tables?
>
>I don't think you need to trim your data, but I suppose it *could* depend on how your front end is handling the data.

It also depends on SET ANSI_PADDING for connection to SQL Server with ON been default and recomendended setting. When it's set to ON the trailing spaces in the character values inserted in the varchar fields are not trimmed and stored as is.