In this short SQL tutorial, I demonstrate the power of pattern matching with the SQL Server PATINDEX function. This is essentially the concept of regular expressions.
I'll break down the PATINDEX syntax, compare the differences between CHARINDEX, look at an interesting Q & A data example and then we'll work through a common issue where we can use PATINDEX, SUBSTRING, LEN, REPLACE and a CTE to get our desired result.
Enjoy!
🤝 Connect with me on LinkedIn:
[ Ссылка ]
🤝 View my Website:
[ Ссылка ]
🖥📝 I also have a great value 2 hour data career consultation service to get you on the right track. Covering resumes, ATS, data technology, soft skills, roadmaps and a take home document pack at great value. Check out the Fiverr gig below:
[ Ссылка ]
