Is there a Proper case function in SQLServer7 such as VFPs PROPER(). I see there is a ltrim() and rtrim() and upper() and lower() which is great, but no proper type function that I could find. Thanks.

John.