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
7967 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

Why is normalization important?

1026

What are different joins used in sql?

1055

What is the use of sqldataadapter?

968

What are the different schemas objects that can be created using pl/sql?

1024

Give the order of sql select?

1133

What are pl/sql packages?

1102

what is bcp? When does it used? : Sql dba

988

What are the constraints available in sql?

1046

What will you get by the cursor attribute sql%rowcount?

1035

Are pl sql variables case sensitive?

1045

What is a table partition?

1127

How we can update the view?

1049

How many types of literals are available in pl sql?

1115

What is the difference between execution of triggers and stored procedures?

1115

How to take user input in pl sql?

1161