Simple-Talk.com came out with a great article titled SQL String User Function Workbench
It has some great sql functions that I’ve spent hours looking for in the past (or had to write myself):
- Split function
- SplitLines
- Within (not from python)
- EndsWith
- StartsWith
- Contains (not from python)
- Join
- Parts (not from python)
- Partition
- RPartition
Anyway, I bookmarked it to go back to in the future.