Click here to Skip to main content
14,870,261 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to remove white space before particular word in sql. i mean how to write sql query for that.

for ex. if i have value like "my name is dvorkin" in a column. And i want result like "my name isdvorkin". Remove space only before 'dvorkin' word. How to write query for that???
Posted

1 solution

Try:
SQL
UPDATE myTable SET MyColumn = REPLACE (MyColumn, ' dvorkin', 'dvorkin')


But try it on a backed up DB first, just in case you change your mind...
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900