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 ] )

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: