OrangeScape Developer Community

A community for Application Developers on OrangeScape's Platform-as-a-Service

November 2009 Blog Posts (1)

Capitalize first letters of words - MSSQL

Problem :



In Oracle we have a function called "INITCAP()" which Capitalize first letters of words



When i tried to find a equivalent function INITCAP in MS SQL Server i found only UPPER and LOWER functions. So i came up with something like this as shown below





Solution :



Example : Take FirstName and LastName from User_ table



Query if you are trying to change a single field : Eg : First Name:… Continue

Added by VM.Hanitha on November 18, 2009 at 3:22pm — 1 Comment

Monthly Archives

2013

2012

2011

2010

2009

2008

2007

© 2017   Created by OrangeScape Technologies.   Powered by

Badges  |  Report an Issue  |  Terms of Service