How to make first letter capital in string and capital first letter after dot.

• koti.raavi

  SSCrazy

  Points: 2756

  More actions

  December 1, 2015 at 4:41 am

  #305711

  I/P: SENT REQUEST TO BREC TO VALADATE. WHY OOA LETTER WAS SENT. PER

  O/p: Sent request to brec to validate. Why ooa letter was sent.Per

  Any help greatly appreciated

  Thanks,

  Dan

• serg-52

  SSCrazy Eights

  Points: 9913

  More actions

  December 1, 2015 at 5:46 am

  #1843158

  Try this

  declare @s-2 varchar(8000) ='SENT REQUEST TO BREC TO VALADATE. WHY OOA LETTER WAS SENT. PER'

  select stuff(

  (select '.'+upper(left(item,cappos))+lower(substring(item,cappos+1,8000))

  from(

  select *, cappos= patindex('%[^ ]%',item)

  from DelimitedSplit8K(@s,'.')

  ) t

  order by ItemNumber

  for xml path('') )

  ,1,1,'')

  Find DelimitedSplit8K code here http://www.sqlservercentral.com/articles/72993/