Return to Answer

added 19 characters in body

Source Link

edited Jul 27, 2017 at 8:05

31.6k
13
101
149

-- 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())

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())

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

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

-- 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())

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

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))

Source Link

created Jul 27, 2017 at 5:05

Romiko Derbynew

-- 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())

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