Author Topic: How to convert a name(string) into proper case  (Read 2561 times)

prapa.shah

  • Newbie
  • *
  • Posts: 4
    • View Profile
How to convert a name(string) into proper case
« on: October 23, 2012, 04:35:34 PM »
Code: [Select]
Declare @strName varchar(10) = 'roHini'
select (SUBSTRING (upper(@strName),1,1) + SUBSTRING (lower(@strName),2,LEN(@strName)))

Ritesh Shah

  • Administrator
  • Jr. Member
  • *****
  • Posts: 57
  • Ritesh Shah
    • View Profile
    • IT Technology Blog
Re: How to convert a name(string) into proper case
« Reply #1 on: October 30, 2012, 03:48:55 PM »
Keep up doing good work Prapa.
Ritesh Shah
Administrator
Extreme-Advice.com
SQLHub.com