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


Please Help Members By Posting Answers For Below Questions

What is a synonym for manipulation?

553


Is t sql the same as sql server?

522


What are trace flags and mention a few common trace flags used with sql server?

556


What is a covered index?

523


how to do partition in sqlserver

1975






What are constraints in microsoft sql server?

565


What are the types of database schema? : sql server analysis services, ssas

602


Explain full-text indexing?

518


What is query and its types?

516


What are secondary xml indexes?

574


What is named calculation? : sql server analysis services, ssas

535


When a primary key constraint is included in a table, what other constraints does this imply?

603


What is change data capture (cdc) feature?

594


What are the ways available in sql server to execute sql statements?

575


What is dbcc updateusage?

540