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
- 4085 Views
- I also Faced
- E-Mail Answers
Answer Posted / radhakrishnan
select replace('radha krishnan',' ','-')
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How to create percentile function?
Where cross join is used?
Can a table have 2 foreign keys?
In what three ways is the return statement used in a stored procedure?
Do you know what is sql service broker?
Which is better statement or preparedstatement?
What is dbcc? Give few examples.
How to test a dml trigger in ms sql server?
What are the restrictions that views have to follow?
What is the difference between a clustered index and a non-clustered index?
What is PROJECTION Operation?
What is the difference between index seek vs. Index scan?
System variable and temporary variables
What is autocommit mode in sql server?
Which table keeps the locking information?
