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 : 1
Answer 1
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 : 
Password :   
Forgot your password
Don't have StepCoder account ?
Create a new account
Follow me on twitter
About Me
Harpreet Singh
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.