PROPER
Updated: 30 April 2009
Use PROPER to capitalize the first letter in each word of a string of text.
Syntax
SELECT [wctString].[wct].[PROPER] (
<@Text, nvarchar(max),>)
Arguments
@Text
is the text value to be evaluated. The @Text argument can be of data types that are implicitly convertible to nvarchar or ntext.
Return Types
nvarchar(max)
Remarks
· PROPER capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter.
· PROPER converts all other letters to lowercase letters.
· PROPER only capitalizes [a-z].
Examples
select wct.PROPER('now is the time for all good men to come to the aid of their country')
This produces the following result
-----------------------------------------------------------------------
Now Is The Time For All Good Men To Come To The Aid Of Their Country
(1 row(s) affected)