reduce spaces between data

[Humair]

hi
i have table named t1 having column

a b
----------------
1 a s d
2 c v b
3 s d f g h
4 d f
5 b g ty gggg

then i want

display a record of column "b"
like this

asd
cvb
sdfgh
df
bgtygggg

so on & so on

basicaly i am reduce spaces between data

any method to reduce spaces in sql server only?
bye

[Paul Mc]

G'day Humair.


>a b
>----------------
>1 a s d
>2 c v b
>3 s d f g h
>4 d f
>5 b g ty gggg

Try this:

Select REPLACE([b], ' ', '') as B_NoSpaces From t1

HTH,
Cheers,
Paul