you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required
- 3 Answers
- 3899 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhakar
use replace function
select replace(a,' ','-') from sub_string
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is PROJECTION Operation?
What is abstracting periodical?
Can a database be shrunk with users active?
can an automatic recovery be initiated by a user? : Sql server administration
What are partitioned views?
Why use cursor in sql server?
What is identity?
Find nth lowest salary or get nth lowest salary?
What is an identity?
What is an indexing strategy?
What are the grouping functions?
What is buffer cash in sql server?
Can We Use Data-grids For Our Report In Ssrs?
Explain index in sql server?
Can you please explain the difference between primary keys and foreign keys?
