This example concatenates noncharacter expressions by using CAST. It uses the AdventureWorksDW database. SELECT 'The list price is ' + CAST(ListPrice AS VARCHAR(12)) AS ListPrice FROM dbo.DimProduct WHERE ListPrice BETWEEN 350.00 AND 400.00;