white spaces

[deddleston]

How do you remove white spaces/carriage returns from a given string (end of).

pls give an example if you can.

Thanks M$ arn't the only option!

 

[JamesLean]

You can use the RTRIM function to strip trailing blanks, however I don't think it will work for carriage returns.

str1 = 'this is a string       '
RTRIM(str1) = 'this is a string'

(You can use LTRIM to strip leading blanks too). --James

 

[deddleston]

Ok, i'm using ms sql server 2000, dunno if it makes a difference. but it say's "incorrect sytax near '='" M$ arn't the only option!

 

[cmhunt]

Deddleston, I think your understanding is not there. To see example working,

DECLARE @str1 AS varchar(30)
SET @str1 = 'this is a string '
SELECT RTRIM(@str1)

 

[deddleston]

dammit.... i missed of the select!!!!

DECLARE @str1 varchar(60)
SET @str1 = 'this is a string '
RTRIM(@str1)

thanx for your help M$ arn't the only option!

 

[deddleston]

How would i take out carriage returns in the middle of a string? leaving the white spaces?? M$ arn't the only option!

 

[JamesLean]

Try using the REPLACE function:

SELECT REPLACE(str1, CHAR(13), '')

(13 is the ASCII value of a carriage return). --James

 

[deddleston]

ic ic cheers M$ arn't the only option!