The CONVERT function has the following syntax:CONVERT(datatype [(length)], expression [, style])Here's an example that uses CONVERT in the select list to convert the title column to a char(50) column so the results are more readable:SELECT CONVERT(char(50), title), ytd_sales FROM titles WHERE type = 'trad_cook'title
FROM titles
WHERE type = 'trad_cook'title