Thursday, January 1, 2009

Getting first character of string in caps (sql server)

Following is a small demonstration of getting the first character of a string in capital letter.

print upper(left('manas', 1)) + right('manas', len('manas') - 1)