Posted by Greg D. Moore \(Strider\) on 02/21/07 15:33

"Erland Sommarskog" <esquel@sommarskog.se> wrote in message
news:Xns98DE80DCF284AYazorman@127.0.0.1...
> Mintyman (mintyman@ntlworld.com) writes:
>> I have erronous white space at the end of my 'description' field within
>> my
>> 'product' table. I tried using the RTRIM function but it won't let me
>> because it is a TEXTBLOB (text) field.
>>
>> Can anyone show me how to write a query that will update all my rows
>> automatically?
>>
>> I'm using SQL Server 2000.
>
> The easiest would almost be to download SQL Express, copy the data
> over to a table in SQL 2005, but instead of using text, have a
> varchar(MAX)
> column, on which you can apply rtrim. Then copy back.
>

Or use BCP in character mode, dump out into a perl script, modify, and BCP
back in.

--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com

[Back to original message]