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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

Question Posted / mani


in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,m..

Answer / Aman Kumar Chaudhary

You can achieve this by using the SQL REPLACE function. In SQL Server, you can use this query: SELECT REPLACE(REPLACE(REPLACE(k, 'manikanta', ''), 'sivananda', ''), 'muralidhar', '') as new_name FROM your_table; Replace 'your_table' with the name of your table.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

How do I view a stored procedure in sql server query?

1 Answers  

What is the command to change the recovery model?

1 Answers  

What is a db view?

1 Answers  

What do you do in data exploration

1 Answers   EXL,

What is referential integrity and how is it achieved?

1 Answers   Adea Solutions,

What is catalog views?

1 Answers  

Explain logical operators in sql server?

1 Answers  

What is the difference between osql and query analyzer?

1 Answers  

Differentiate between truncate vs delete in mssql?

1 Answers  

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 as it is,how?

1 Answers  

Explain foreign key in sql server?

1 Answers  

Is it possible to delete duplicate rows in a table without using a temporary table ?

12 Answers   TCS,

For more SQL Server Interview Questions Click Here
Categories