Removing ALL Spaces from Variables

[quinnipiac0807]

This could be a dumb question but I'll give it a go anyway. I'm using SQL Server 2000, and I'm trying to take a variable and make sure it has no spaces in it, ANYWHERE!!! As easy at this seems it's really confusing me.

Ex. - If a varibalbe looks like this 'Lee Ann', I want to change it to this, 'LeeAnn'.

The reason I'm doing this is because I'm creating email addresses from a very long list of first names and last names, and spaces are a no go in email addresses.

I know this is probably pretty easy, but thanks in advance for the help.

 

[gmmastros]

use the Replace function

Replace('Lee Ann', ' ', '')

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[dbomrrsm]

declare @text varchar (10) ,@textnospace varchar (10)
set @text = 'Dave Hull'
set @textnospace = replace(@text,' ','')
select @text
select @textnospace

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[quinnipiac0807]

Thanks. I was trying to use the trim function which was, obviously, only taking care of half of my problem.