Concate SQL

SELECT        CONVERT(varchar(50), Id) + ' ' + CONVERT(varchar(50), ProductionID) AS ConcatnatedColumn
FROM            Production.CPOProduction


=========================OR==================


SELECT        'Ipl' + CONVERT(varchar(50), Id) + '' + CONVERT(varchar(50), ProductionID) AS ConcatnatedColumn, Id, ProductionID, EstateID, ActiveMonthYearID, CropYieldID, CPOProductionDate, QtyToday, QtyMonthToDate,
                         QtyYearToDate, CreatedOn, CreatedBy, ModifiedBy, ModifiedOn, CPODate, TankID, DataAreaId
FROM            Production.CPOProduction