1

I want to know what is the equivalent for 'InitCap' in oracle to mssql with out creating addition function like 'dbo.initcap()'.can any one help me how to get this with out using function.

steve
  • 666
  • 3
  • 15
  • 41
  • Possible duplicate: [How to update data as upper case first letter with t-sql command?](http://stackoverflow.com/questions/11688182/how-to-update-data-as-upper-case-first-letter-with-t-sql-command) – Pred Sep 24 '14 at 09:16

1 Answers1

-1

You can try it with something like

concat(ucase(substr(yourstring, 1,1)), substr(yourstring, 2))
Leo Chapiro
  • 13,405
  • 7
  • 56
  • 87
  • The above code capitalizes only the first character of the string. Oracle's InitCap capitalizes the first letter of **EACH** word. – vchan Jan 15 '20 at 15:35
  • concat(upper(substring ('yourstring', 1,1)), lower(substring('yourstring', 2,len('yourstring')))) – Dandy Jul 22 '21 at 07:26