Remove Extra Space between string in whole column

Apr 6 2017 3:22 AM

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

Answers (4)