Remove/Replace White Space in Columns

Transact-SQL
1

Hello Community,

Can someone please let me know how to remove or replace white spaces in columns

whitespace
whitespace.png893×65 24.7 KB

I would like to either remove the white space from the columns shown in the image and/or replace the white space with an underscore.

I would also like to remove the brackets.

Any help greatly appreciated.

Cheers

2

Please try this

UPDATE table_name SET "column_name"=
replace("column_name", ' ', '_');

3

Did my solution work Carlton

:thinking::thinking:

4

Hi Harishgg1

It appeared to work - meaning I didn't get any errors, but I'm not sure how to display the results...

5

What that does is updates the data in the
Table

Now all you do is select the column s

You should not see any spaces but underscores

6

Is this for Microsoft SQL Server ?
Are you trying to replace the column name of a table or column name of a result from a query?

7

I should mention that I'm using an application called dbForge for SQL Server.

When I execute the query I get the following, tellimg me do I want to execute the UPDATE statement

doyou
doyou.png745×220 42.5 KB

When I say yes nothing happens

I think its a function of the program

8

Try this

Select replace(column,' ','_')
From table

9

I get the follow when I enter:

Select REPLACE([Resolution Summary], ' ', '_')
From dbo.DAY_REPORT

null

10

are all values NULLS ???

11

Hi harishgg1

It turns out that in this instance the values are NULL. However, that is immaterial as I just need the column to be change from Resolution Summary to ResolutionSummary

12

so your problem is resolved !!!

??