Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kgs_ETL
Starting Member
1 Post |
 Posted - 2011-03-23 : 13:47:59
|
| Hi All,I am loading the data from ETL tool into SQL server 2008. I basically wants to do the rtrim on my columns. for example There in a column in my table say "City varchar(5)". and there is a row in my source say "abcxyz" which has length 6. So i just want "abcxy" in my target.Is there any way I can do this automatically on all of my columns? I mean auto RTRIM on row data if it doesn't satisfy the max column length. Thanks,Krunal |
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2011-03-23 : 13:57:38
|
| left (city,5), but it isn't automatic, you have to program itJimEveryday I learn something that somebody else already knew |
 |
|
|
|
|
|
SQL server 2008 auto truncate column