A. SQL has a reasonably full set of string manipulation tools - all doc'd in the BOL. Some are detailed below.
- RTRIM/LTRIM - for leading/trailing spaces
- SUBSTR - standard substring
- CHARINDEX/PATINDEX - find a particular char/pattern
- STUFF - replace text at given offset(s)
- REPLACE - SQL 7.0 only. Replaces chars anywhere in a column