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
7886 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 difference between procedure and trigger?

958

What are the types of variable use in pl sql?

1055

What is sorting in sql?

926

Explain the difference between rename and alias?

1000

What is exception? What are the types of exceptions?

1060

what is foreign key? : Sql dba

1000

define sql delete statement ? : Sql dba

1001

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

963

What's the procedure?

912

What is sql deadlock?

1112

Is oracle and sql same?

991

how can we submit a form without a submit button? : Sql dba

963

what is a database? : Sql dba

1140

What is a system versioned table?

958

How can a pl sql block be executed?

932