select substring(NAME,1,charindex(' ',NAME))+' '+ rep

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 / lince

5 Answers
8156 Views
I also Faced
E-Mail Answers

Answer Posted / lince

select substring(NAME,1,charindex(' ',NAME))+' '+
replace(substring(NAME,charindex(' ',NAME),len(NAME)),' ','')
as NAME from test

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What does truncate mean in sql?

1085

Do ddl statements need commit?

1023

Why do we need a foreign key?

1167

what is a constraint? : Sql dba

1233

What is normalization? How many normalization forms are there?

1141

what is a cursor? : Sql dba

1066

How to display the current date in sql?

1129

What is sql partition function?

1290

What is bulk collect in pl sql?

1158

What is sql*loader?

1285

how many columns can be used for creating index? : Sql dba

987

How to assign sql query results to pl sql variables?

1146

how many groups of data types? : Sql dba

1076

Can a select statement fire a trigger?

1210

How to change the order of columns in Oracle SQL Plus ?

1102