Such function does exist - CAST ( { expression | NULL } AS data_type [(length)] ). CAST NULL option is especially useful in queries with UNION which require column types match.