jeudi 26 novembre 2015

SQL SERVER - Removing CHAR( 13 ) and CHAR( 10 ) at the end of the variable

I'm wonder if there is any way for removing CHAR( 13 ) and CHAR( 10 ) at the end of the variable. I got this :

SELECT @TEXT

@Text is a very long line with a lot of CHAR( 13 ) and CHAR( 10 ). I just need to remove it when those CHARS are at the end of the line. Is it posible?

Thank you in advance.

Aucun commentaire:

Enregistrer un commentaire