SQL Server Transact Basic to Expert - Select Query with string Concatenation

This blog shows how to use a string concantenation with the Select query to provide a better result.

Syntax:

Select 'String1' + 'String2' + columnname
From table
Where Condition

Example:

Select 'Welcome ' + empname + '!!'
From emptable
Where empid = '1'

Result - Welcome Karthik!!!