Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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 are transactions in sql?

1069


What are the different types of lock modes in sql server 2000?

949


How to make a column nullable?

1124


How can I track the changes or identify the latest insert-update-delete from a table?

971


What the different components in replication and what is their use?

957


What are types of subqueries?

1071


Any one plz send me SQL Server Developer/DBA resume for 4 years experience

2760


Do you know clustered and non-clustered index?

979


What are diverse clauses that form a part of sql?

1072


How does stuff differ from the replace function?

1018


How to remove duplicate rows from table?

1253


List out the differences between the clustered index and non-clustered index in sql server?

1010


how to avoid cursors? : Sql server database administration

976


Explain sql server service broker?

982


How do you create an execution plan?

954