Trim function

[sandeepk84]

hi all..
i have a doubt...how we can remove blank spaces
in a column value while retrieving?
i tried using LTRIM(RTRIM(COL UMN NAME))...
But it's removing only the leading and trailing spaces...
how i can remove spaces in between?
anybody please help...
thanks and regards,
Sand...

[scripto]

hi all..
i have a doubt...how we can remove blank spaces
in a column value while retrieving?
i tried using LTRIM(RTRIM(COL UMN NAME))...
But it's removing only the leading and trailing spaces...
how i can remove spaces in between?
anybody please help...
thanks and regards,
Sand...

Replace(COLUMN_ NAME, " ", "")

[lordspace]

I think that will erase all the spaces.
Trim should erase leading and trailing white spaces
oopps
your answer is correct, the other user requested to delete all spaces.

[heberd]

SQL Trim

Look at http://sqltrim.codeplex.com for a function that will trim spaces from a string

[trajender]

replace(replace ( cast(ba.heading 1 as varchar),'<p>', ''),'</p>','')

[jonno99]

Try this simple whitespace remover

This should handle any variation of whitespace:

declare @text varchar(500)
set @text = 'delete      white      space' -- add as many spaces between the words as you want...
set @text = replace(replace(replace(replace(replace(@text,'     ',' '),'    ',' '),'   ',' '),'  ',' '),'  ',' ')
print @text

Note: if you know that your whitespace count will never exceed 30 spaces, you can omit the '5 spaces' iteration.
Important Note: don't click on 'Wrap' - it messes up the formatting. If you did click wrap, refreshing the page seems to return things to normal...