proper case in ssrs

SSRS does not contain an inbuilt method for making the first letter of each word uppercase. we can write  uppercase(left(field,1)) + lowercase(right(field,len(string)-1) to do the same job but it gets over complicated and it only modifies first letter of a multi word string. We can use the following function to convert string to proper case….