Handy SQL Server Functions Series (HSSFS) Part 2.0 - Prelude to Parsing Patterns Properly
- by Most Valuable Yak (Rob Volk)
In Part 1 of the series I wrote about 2 lesser-known and somewhat undocumented functions. In this part, I'm going to cover some familiar string functions like Substring(), Parsename(), Patindex(), and Charindex() and delve into their strengths and weaknesses.
I'm also splitting this part up into sub-parts to help focus on a particular technique…