tsql concat string code example

Example 1: sql server concat string and int

SELECT 'Comments: ' + CAST(9 AS varchar(12)) AS Result;

Example 2: select count concat string sql server

'Express 24: ' + CAST(
    (
    SELECT  COUNT(Product) 
    FROM    [DHL].[dbo].[F_SubBetsy](@startdate, @enddate, 
                                    'EXPRESS EXPRESS 24', @contract, @account) 
    ) as varchar(16)) +
'\r\nExpress 48: ' + (SEL...