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
7723 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 is indexing oracle sql?

1023

what are the features and advantages of object-oriented programming? : Sql dba

950

What is a null value?

1080

What is difference between group by and partition by?

976

What is the difference between inner join and left join?

935

what is the difference between delete and truncate statement in sql? : Sql dba

1124

What is the main difference between sql and pl/sql?

1024

How many subqueries can be nested in a statement?

931

What is the order of sql select?

984

Is vs as in pl sql?

932

What is tuple in sql?

1004

How do I know if I have sql express or standard?

975

What is sql not null constraint?

980

Why do we need a foreign key?

1016

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

895