View All Articles
View All Questions
How to remove white space before particular letter in sql
I want to remove white space before particular letter in sql. For example i have a sql column which contains value like "My Name is Prince". Let's say i have to remove white space before a letter 'P'. Then result should be like "My Name isPrince". Hope you understand my question.. Any help would be appreciated.
Posted by Prince Mahajan 3/23/2014 4:58:04 PM
Total Answers :
Try like this :
UPDATE myTable SET MyColumn = REPLACE (MyColumn, ' Prince', 'Prince')
It will replace "My Name is Prince" to "My name isPrince". I hope that is what you want.
Posted by StepCoder Team 3/25/2014 12:28:23 PM
Post your answer
Sign in to your account
Your Email :
Forgot your password
Don't have StepCoder account ?
Create a new account
Follow me on twitter
I began programming with C++ when i was 17. Then at the middle of my study .NET came. Then I began to read C# and VB.NET. By the time i learnt SQL and ASP.NET, and developed some websites such as news portals that are active now. Currently i am running my own Software company.
Answer these questions! If you know the answer.
How to solve Database Error
SIR PLEASE LEAVE ARTICLE ACCESS DATABASE AND CRYSTAL REPORT WITH SETUP
Showing all records from a dataset in report viewer
how to create rss in asp
Update project but keep database records
Create setup for Visual studio Csharp project including database
how to create setup only important file
How to save all the items from a listview into a access database
how to add crystal report prerequisites in setup file
How to show alert box automatically in windows Application
Paging in DataGridView
Visual Studio 2010
Asp.Net Sample Source Code
C#.Net Sample Source Code
Setup and Deployment
Bacup and Restore
Programming Interview Questions
Beginner Asp.Net Tutorials
Beginner C#.Net Tutorials
Starter Asp.Net Tutorials
Starter C#.Net Tutorials
© 2013 Near Bizz. All Rights Reserved.