SQL--Convert (binary) in to string using sql

/* datafield--->binary(imageformat) field in table (or blob field in mysql)*/
/* in ms sql give the following code...*/

Convert(char,Convert(binary,datafield)))

/* in my sql give the following code...*/

cast(datafield as char)