How to use initcap function in sql server?
Can any one give me the syntax for intcap function in sql server 2005.
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
HanookPosted Nov 7, 2013, 11:53 PM
Use the follwoing user-defined function(UDF ) to get the same functionality
Reference: You can refer this link for knowing the usage of UDF
http://www.sql-server-helper.com/functions/initcap.aspx
VulpesPosted Nov 6, 2013, 7:16 AM
However, you can write your own function to do the same thing. Check out this thread:
http://stackoverflow.com/questions/11688182/how-to-update-data-as-upper-case-first-letter-with-t-sql-command