fn_proper (Transact_SQL)

See also: 


 This scalar UDF set the first character in each word to upper case and the rest to lower case, similar to Excell PROPER function.
 

Syntax

 fn_proper(@string) 



Arguments

@string = NVARCHAR(4000) , string to apply the PROPER formating onto;

 

Return type

NVARCHAR(4000)

Remarks

none

 

Permissions

Public

 

Dependencies

none

 

Examples

SELECT* FROM [Lib].[tsql].[fn_proper]('john smith')

John Smith

 

Other

none

 


Last edited Aug 22, 2012 at 5:47 PM by adudau, version 6

Comments

No comments yet.