select substr(name,1,instr(name,' ',1)-1)||substr(name,instr(name

Like shown below i have 3 columns(Name,No,Address). The
values in name column i want to modity.
Requirement : Keep only once space between two words
(Fname,Lname) in the Name column.
For this what is the query? Please answer me. Advance
Thanks.

Name No Address Reference

manoj kumar
kumar raja
vinzay kumar
rajendra prasad
gowri nath -- -- --

Question Posted / swastik

5 Answers
7980 Views
I also Faced
E-Mail Answers

Answer Posted / swastik

select substr(name,1,instr(name,' ',1)-1)||substr(name,instr(name,' ',-1),length(name)) from spacename

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are sql data types?

1029

How to select 10 records from a table?

1157

What is the usage of sql functions?

1146

How do I find sql profiler?

943

What is the maximum number of rows in sql table?

1030

How to avoid duplicate records in a query?

1008

Explain what is a subquery ?

1188

Can unique keys be null?

912

What is sql*plus?

1082

Is a table valued function object?

1023

Is pl sql a programming language?

994

What is the best partition size for windows 10?

1003

What is difference between db2 and sql?

1001

What is difference between table and view?

1057

what are date and time intervals? : Sql dba

1057