T-SQL UpperCase first letter of word

I am amazed by the complex solutions out on the internet to upper case the first letter of a word in SQL. Here is a way I think is nice and simple.


-- Test Data

declare @word varchar(100)
with good as (select 'good' as a union select 'nice' union select 'fine')
select @word = (SELECT TOP 1 a FROM good ORDER BY NEWID())

-- Implementation

select substring(Upper(@word),1,1) + substring(@word, 2, LEN(@word))

One thought on “T-SQL UpperCase first letter of word”

  1. Romi – I think this will work if in fact you only have single whitespace, such as John Smith. What of cases where you have John Smith Adams. Or it is not eneough a name it is a street Address such as “9101 Adam Smith Blvd”.

    Reply

Leave a reply to Daniel Adeniji Cancel reply