Remove Extra Space between string in whole column

Question

I want to Remove Extra Space between string in whole column using a single query. I have value ???? ????? ?????? ??. 84/214 ??????? ?????  I want to remove extra space from the name ??????? ?????. I want to this in all database columns at a single query . So send query for this solution. I have tried this but it is not working for column  only working for single sting. Select REPLACE(REPLACE(REPLACE(Oname' ''{}')'}{''')'{}'' ') from own_detl_p21c

Hariharan Krishnamoorthi · Answer

SELECT REPLACE (Oname ' '  '' ) AS Oname FROM own_detl_p21c

Rafnas T P · Answer

hi I am sorry you wanted to remove extra spaces right. the same query which yoy metioned here Select REPLACE ( REPLACE ( REPLACE ( Oname  ' '  '{}' ) '}{'  '' ) '{}'  ' ' ) from own_detl_p21c if red is table column field than it is working perfectly for columns as well.

Rafnas T P · Answer

try below code it will remove all spaces I am assuming that red is table column field which you wanted to remove all spaces Select REPLACE ( Oname  ' '  '' ) from own_detl_p21c

Srikanth Reddy · Answer

Use built-in Replace() function : select REPLACE (' Hello How Are You ?' ' ' '' )