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
- 4885 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 default constraint?
What do you understand by user-defined function in the sql server?
What is ddl command?
Do I need a report server to run reports in my application?
Does partitioning improve performance?
What is the simplest way to create a new database in ms sql server?
What are the mathematical functions supported by sql server 2005?
What are the advantages of user defined function?
Define left outer join?
What is collation sensitivity?
how to invoke a trigger on demand? : Sql server database administration
What are the advantages of having an index on the sql server?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How to enable tcp/ip protocol on a sql server?
Where cross join is used?
