tag:blogger.com,1999:blog-4149930.post5462186547713846840..comments2023-08-10T10:53:35.019-04:00Comments on SQL Soundings: Remove All Text Between Single QuotesLarry Leonardhttp://www.blogger.com/profile/01248746755565439137noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-4149930.post-53328397605763982842020-01-14T22:11:49.215-05:002020-01-14T22:11:49.215-05:00Very helpful code, thank you!
Can I suggest possi...Very helpful code, thank you!<br /><br />Can I suggest possibly wrapping your whole STUFF function in an ISNULL with the original string to handle records which don't have any of the delimiter characters you are trying to remove (e.g. the single quotes in your example). When I tried to implement this for my code I found that the records which didn't contain any delimiters were returning NULL values (not what I wanted).Anonymousnoreply@blogger.com