Login     Register

        Contact Us     Search

XLeratorDB/strings Online Documentation

SQL Server PROPER function


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)


Copyright 2008-2017 Westclintech LLC         Privacy Policy        Terms of Service