Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vladimir_grigoro
Yak Posting Veteran
62 Posts |
 Posted - 2004-07-30 : 05:47:52
|
| Hi All,I have a varchar column with values like:AS 23 34 56FD 21 34 45and I want to make a query, which should return a result like:AS233456FD213445e.g. I want to remove spaces in the values.Thank you in advance.The Rebel |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-07-30 : 05:51:56
|
| look at the REPLACE function. |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-30 : 08:44:02
|
| SELECT REPLACE(column_name,' ','') AS column_nameFROM tableMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
TRIM SPACES