Google Answers: SQL Programming: rtrim character manipulation

View Question

Q: SQL Programming: rtrim character manipulation ( No Answer, 0 Comments )

Question

Subject: SQL Programming: rtrim character manipulation
Category: Computers > Programming
Asked by: cyntlhiadiane-ga
List Price: $5.00

Posted: 22 Oct 2003 15:51 PDT
Expires: 22 Oct 2003 16:22 PDT
Question ID: 268794

I have a varchar(2) column and some of the field values (not all) have
trailing white space such as a carriage return.  How can I trim the
trailing carriage return and then save the data?  This does not work:

update table
set my_column = rtrim(my_column)

Answer

There is no answer at this time.

Comments

There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.

Search Google Answers for

Google Home - Answers FAQ - Terms of Service - Privacy Policy