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

Santosh Kumar

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).

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Trivedi12y ago
hi,

agree with above answer you can use replace function to remove the space
select replace(' A - B - C - D - E',space(1),'')

refer
http://msdn.microsoft.com/en-us/library/ms186862.aspx
to know more about relace function

hope this will help you.
Hanook12y ago
SELECT REPLACE ( ' A - B - C - D - E', ' ', '')

OUTPUT:
A-B-C-D-E

So the SELECT query as follows:
SELECT REPLACE ( sequence, ' ', '')
FROM TableName;
Jaganathan Bantheswaran12y ago
Mark the reply as Answer if that helped you.
Jaganathan Bantheswaran12y ago
Hi,

Try like this,

SELECT REPLACE(Sequence, ' ', '') from YourTable;