-- sql server SELECT CONVERT(NVARCHAR(100), 10) AS Result SELECT CONVERT(VARCHAR(100), 10) AS Result
convert(datatype, (column_name|value))