Posted by Mintyman on 02/21/07 10:37

Hi,

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.

Thanks!

• Next in forum: Re: Use RTRIM function on TEXTBLOB (text) field
• Prev in forum: Microsoft Releases SQL Server 2005 Service Pack 2 (PR Newswire via Yahoo! Finance)
• Thread view: Use RTRIM function on TEXTBLOB (text) field

[Reply to this message]