UPPER

Recursive CTE

Common table expressions (CTE)

LOWER, UPPER, SOUNDEX and DIFFERENCE functions

String functions in MS SQL SERVER