Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 deleting strings within sql table field

Author  Topic 

michael999
Starting Member

9 Posts

Posted - 2012-12-27 : 09:32:13
hi
What is the sql required to remove a substring from within a column on the database please?
I have to get it right because I cannot affect the rest of the data in each column.
thanks
michael

sunitabeck
Master Smack Fu Yak Hacker

5155 Posts

Posted - 2012-12-27 : 09:40:38
Typically one would use STUFF or REPLACE functions for the removal along with CHARINDEX or PATINDEX functions to identify the characters that need to be removed. There are examples on the links on this page
Go to Top of Page
   

- Advertisement -