Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4762 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
How to drop an existing user defined function in ms sql server?
How to use clusters?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
What is normalization according to you and explain its different levels?
What is a linked server in sql server?
Explain about analysis services?
How do I know if localdb is running?
What is molap and its advantage? : sql server analysis services, ssas
What are the drawbacks of reporting in ssrs?
When to use null data driven subscription?
Can I save my report as html, excel or word? : sql server management studio
What are dml triggers and types of dml triggers?
Do you know what are acid properties?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What do you mean by sql server 2005 express management tools?
