Remove spaces from string

[davetek]

Hi,

I have a string in the format '001 555 2391'.

I want to convert this to 0015552391.

Any suggestions?

Thanks.

 

[SQLDenis]

select replace(field,' ','')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[davetek]

The database i'm using actually does not allow replace function.

 

[SQLDenis]

I assume you used SQL server since this is a SQL server forum
what db are you using?

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/