SQL server CAST and CONVERT int to Varchar

Transact-SQL Reference (SQL Server 2000)

CAST and CONVERT

SQL server CAST and CONVERT int to Varchar

USE pubs
GO

SELECT 'The price is ' + CAST(price AS varchar(12))
FROM titles
WHERE price > 10.00


GO

Price is integer filed - convert into varchar on select