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 -- -- --
- 5 Answers
- 7018 Views
- I also Faced
- E-Mail Answers
Answer Posted / kavitha n
SELECT NAME,
( SUBSTR (NAME, 1, (INSTR (NAME, ' ', 1)))
|| ''
|| SUBSTR (NAME, INSTR (NAME, ' ', -1), LENGTH (NAME))
) output
FROM test;
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
What is join view in sql?
What is before and after trigger?
How does cross join work?
who introduced sql?
What is your daily office routine?
What is posting?
how to drop an existing index in mysql? : Sql dba
What is trigger with example?
What are % type and % rowtype?
what is online transaction processing (oltp)? : Sql dba
Is sql open source?
What is restrict in sql?
what are date and time data types? : Sql dba
what are the 'mysql' command line arguments? : Sql dba
How do you explain an index number?
