I'm importing a text file with DTS. It seems upon import all the text values
in the table have a bunch of extra spaces at the end of them. Is this
becuase I have the fields set up wrong? Or is there a way to trim the text
before or after it's inserted?

If I need to run a query to trim them, what is the syntax? It's been a year
or so since i've done ant T-SQL. Thank you.

_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

MS Sql Server LazyDBA home page