This blog provides SQL Server-Power BI-Azure BI -data factory Certification training and interview guidance
If you have any queries/concerns,please feel free to contact me at
www.eclasess.com
Mail: info@eclasess.com Mobile:+919885245722
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