Login     Register

        Contact Us     Search

XLeratorDB/strings Online Documentation

SQL Server PROPER function


Updated: 30 April 2009

Use PROPER to capitalize the first letter in each word of a string of text.
SELECT [wctString].[wct].[PROPER] (
   <@Text, nvarchar(max),>)
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
·         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].
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-2018 Westclintech LLC         Privacy Policy        Terms of Service