Remove blanks from a string

[3270]

Hi

whats the easy way to remove blanks from the at string?
If i got a string like this 'xxx yyy z zz' and i want it to look like this 'xxxyyyzzz' is there then a simple solution?

example thats doesnt work:

declare @String varchar(20)

select @string = 'xxx yyy z zz'

select @string = replace(@string ,' ','')

 

[SQLDenis]

That works for me, where doesn't it work for you?

declare @String varchar(20)

select @string = 'xxx yyy z zz'

select @string = replace(@string ,' ','')
select @string


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[3270]

On a Sql 2000 server in 6.5 mode and @@options = 0

 

[SQLDenis]

what output do you get?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[3270]

When i use the replace proecdure nothing happends, the ouput is 'xxx yyy z zz'
if i write select @string = replace(@string ,' ','*')

the output is 'xxx*yyy*z*zz'

 

[SQLDenis]

what about
select @string = replace(replace(@string ,' ','*'),'*','')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[3270]

select @string = replace(replace(@string ,' ','*'),'*','') doesnt work for me either.

if my statements is like this
select @string = 'aaaxxyyy'
select @string = replace(@string,'x','')
the result is : 'aaa yyy'

 

[fredericofonseca]

The idea of an "empty string" was introducted in MS-SQL 7.0, there isn't such a thing as an "empty string" in MS-SQL 6.5.

which is what you are trying to do.

try the following. probably wont work either, and may even give an error.

select @string = replace(@string ,' ',space(0))




Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

 

[3270]

select @string = replace(@string ,' ',space(0))
returns null.

I guess there is no easy solution then.