Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
4
Reply
Remove Extra Space between string in whole column
Mohammed Zaid Meraj
Apr 6 2017 3:22 AM
352
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
How to export text file by xp_cmdshell for Thailand Language
how to insert txt file into database sever