Home » SQL Server » New built-in String functions in SQL Server 2012……..Part 5 of 5

New built-in String functions in SQL Server 2012……..Part 5 of 5

Microsoft SQL Server 2012 introduces 14 new built-in functions. 2 Out 14 explained below.

String functions

· CONCAT : CONCAT takes a variable number of string arguments and concatenates them into a single string. It requires a minimum of two input values; otherwise, an error is raised. All arguments are implicitly converted to string types and then concatenated. Null values are implicitly converted to an empty string.

CONCAT ( string_value1, string_value2 [, string_valueN ] )

· FORMAT : Use the FORMAT function for locale-aware formatting of date/time and number values as strings. This really a good function because converting a date into desired format with convert along with format number is little uneasy.

FORMAT ( value, format [, culture ] )

Leave a Reply

Join us on Facebook

microsoftcommunitycontributor
%d bloggers like this: