SQL Server Transact Basic to Expert - Concantenate Integer and string in SQL Query

Karthikeyan Anbarasan
13y
4.1k
0
0

Blog

This blog shows how to concantenate an integer and a string using SQL query

Example:

SELECT CONVERT(char(4), 2011) + ' - This is Current Year'

The expected result would be 2011 - This is Current Year

SQL Server Transact Basic to Expert - Concantenate Integer and string in SQL Query

Up Next

SQL Server Transact Basic to Expert - Decreasing a date value to 4 months using SQL query

Ebook Download

View all

Introducing Microsoft SQL Server 2016

Read by 11k people

Download Now!

Learn

View all