This is a series of articles on string manipulation techniques. These are mostly beginning programming articles, but advanced T-SQL programmers may still find something useful here.
- Tame Those Strings Part 1 - Using SUBSTRING deals with SUBSTRING and how it can be used to extract some information
from a field of data
- Tame Those Strings! Part 2 - Using CHARINDEX- deals with CHARINDEX and how it can be used to extract some information
from a field of data when the data is delimited rather than stored in a particular format.
- Tame Those Strings! Part 3 - Using REPLACE deals with REPLACE and how it can be used to remove unwanted information
from a field of data when the data is not in a known format.
- Tame Those Strings! Part 4 - Numeric Conversions deals with numbers that can be converted using STR() to get data in a consistent format.
- Tame Those Strings! Part 5 - Using STUFF - uses the STUFF function to reformat a string.
- Tame Those Strings Part 6 - Bending Results - can get data from different places together into one result.
- Tame Those Strings! Part 7 - Proper Casing Strings - A common situation that isn't as simple as it seems.
- Tame Those Strings! Part 8 - Quoting - learning to deal with quote marks inside strings.
- Tame Those Strings Part 9 - Dynamic SQL - using the power of dynamic SQL to build up a string results from multiple sources.
- Tame Those Strings! Part 10 - Finding Carriage Returns - removing carriage returns from strings so they display correctly.