Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7943 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
what is the functionality of the function htmlentities? : Sql dba
what are the advantages and disadvantages of views in a database? : Sql dba
Can I create table without primary key?
How do you update a value in sql?
How do I kill a query in postgresql?
What is difference between mysql and postgresql?
What are the types of variable use in pl sql?
Why truncate is used in sql?
how to show all tables with 'mysql'? : Sql dba
explain about mysql and its features. : Sql dba
What packages(if any) has oracle provided for use by developers?
How to test for null values?
what is cursor. write example of it. What are the attributes of cursor.
How to write a query to show the details of a student from students table whose
What is the use of function "module procedure" in pl/sql?
