[RESOLVED] Remove empty spaces in a String in TSQL

[vuyiswamb]

Good Day All


i have the Following string in a Field

'This
is the 
 
reason that i did this>> '

i want to remove spaces in TSQL to this

This is the reason that i did this>>

THanks

[RhinoBull]

It looks like you need to rename your thread to something like "Remove empty lines and linefeed characters..." instead.

[RhinoBull]

In any case try using Replace function:

REPLACE ( string_expression , string_pattern , string_replacement )

To replace all new line characters try this:

REPLACE(@string, CHAR(13)+CHAR(10), '')

To replace extra spaces you may need to loop and replace every 2 spaces with 1 space.

[vuyiswamb]

Thanks i used this and it worked

declare @NewLine char(2)
set @NewLine=char(13)+char(10)
 
select  rtrim(ltrim(Replace('This
is the 
 
reason that i did this>> ',@NewLine,'')))