Monday, 8 January 2018

Capitalize the first character in SQL Server

CREATE FUNCTION InitCap (
 @string varchar(255)
)  
RETURNS varchar(255) AS


BEGIN 

 RETURN upper(left(@string, 1)) + right(@string, len(@string) - 1) 

END

No comments:

Post a Comment