Rtrim... ish

[B@Th*nG]

hi guys,

i've got some data i want to apply an rtrim to, but it doesn't necessarily have spaces at the end of the field. example:

Celebrations                                   [D]

How can i remove all the annoying spaces and keep the "[D]", or whatever it is, at the end?

B@

 

[B@Th*nG]

perfect, any idea how you'd write that for access or SQL server?

B@

 

[B@Th*nG]

ok fair enough, anyone else have any ideas?

B@

 

[B@Th*nG]

SQL Server would be something like the following surely?

SELECT replace( @Data, ' ', '' )

that would replace all spaces wouldn't it?

B@

 

[B@Th*nG]

probably not the best solution, but the following should work:

declare @myval nvarchar(100)
set @myval = 'Celebrations                                       [D]'
select replace(replace(replace(replace(replace(@myval,'     ',' '), '    ', ' '), '   ',' '),'  ',' '), '  ',' ')

Tried with various lengths of spacing, and it seems to work.

this works perfectly, thanks very much!!

B@