Convert strings to UPPERCASE in SQL Server

Question

What is the T-SQL function for converting strings into upper case in SQL Server?

score 56 · Answer 1 · answered Apr 02 '11 at 04:38

56

SELECT UPPER(LastName) + ', ' + FirstName AS Name
FROM Person.Person

answered Apr 02 '11 at 04:38

Mitch Wheat

score 16 · Answer 2 · edited Aug 23 '18 at 13:12

16

Try UPPER function:

SELECT UPPER('Hello world!!!')

Result:

HELLO WORLD!!!

edited Aug 23 '18 at 13:12

Prashant Pimpale

answered Apr 02 '11 at 05:01

simplyaarti

2 Answers2