In this article you will learn about some SQL String functions.
Functions in SQL Server: Practical Guide