Hi, Eric

Proper() does this.

HTH
>Before I spend a couple hours pounding this out, is there anyone out there that has a T-SQL function that converts a string to Title Case?
>
>For example
>
>"this is a text string" would be converted to "This Is A Test String"
>
>Thanks