Our Training Programs

All contents are copyright of their authors.

Remove Extra Space between string in whole column

Remove Extra Space between string in whole column

Mohammed Zaid Meraj

9yAsked Apr 6, 2017, 3:22 AM1.1k

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

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

It is the same account you read, post and publish with — and you will come straight back to this page.

Hariharan Krishnamoorthi9y ago
1. SELECT REPLACE(Oname,' ','') AS Oname FROM own_detl_p21c

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.

try below code it will remove all spaces

I am assuming that red is table column field which you wanted to remove all spaces

Use built-in Replace() function :

select REPLACE (' Hello How Are You ?', ' ', '' )