How to removes all white spaces from a field in SQL Server

Question

Hi all!
I want to remove all white space in a specific field From a Table in sql server during fetching data from C# code. I want to take all table field but I want to remove spaces from only one field. i am taking data from another server.

Is there any query in which I remove white spaces in create view of that table. Please assist me.


My table fields are like..

user_id           user_name              user_password                  Sequence

1241             rajan121                      12345                          A  -  B   -   C      -    D  - E


I want to remove white spaces from Sequence like (A-B-C-D-E).