CAST(foo AS CHAR(100)) CONVERT(foo, CHAR(100)) Supported types (5.5) are: BINARY[(N)] CHAR[(N)] DATE DATETIME DECIMAL[(M[,D])] SIGNED [INTEGER] TIME UNSIGNED [INTEGER]
VARCHAR