PROPER

Updated 2023-11-10 15:56:09.297000

Syntax

SELECT [westclintech].[wct].[PROPER] (
   <@Text, nvarchar(max),>)

Description

Use the scalar function PROPER to capitalize the first letter in each word of a string of text.

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 Type

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.

{"columns":[{"field":"column 1"}],"rows":[{"column 1":"Now Is The Time For All Good Men To Come To The Aid Of Their Country"}]}