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
Answer Posted / radhakrishnan
select replace('radha krishnan',' ','-')
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What are transactions in sql?
What are the different types of lock modes in sql server 2000?
How to make a column nullable?
How can I track the changes or identify the latest insert-update-delete from a table?
What the different components in replication and what is their use?
What are types of subqueries?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Do you know clustered and non-clustered index?
What are diverse clauses that form a part of sql?
How does stuff differ from the replace function?
How to remove duplicate rows from table?
List out the differences between the clustered index and non-clustered index in sql server?
how to avoid cursors? : Sql server database administration
Explain sql server service broker?
How do you create an execution plan?