Interested to Buy Any Domain ? << Click Here >> for more details...
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
- 1 Answers
- 1570 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
Why and when do stored procedure recompile?
What are the source of constraints?
Why should you use or avoid select * statements?
What is the difference between for xml raw and for xml auto?
Where can you add custom error messages to sql server?
How raid can influence database performance?
What are the kinds of subquery?
What is sql or structured query language?
How to connect php with different port numbers?
How to convert numeric expression data types using the cast() function?
What is clustered index
What is acid mean in sql server?
Can you index views?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
How can you append an identity column to a temporary table?
