You can use CAST or CONVERT thus
CAST(foo AS CHAR(100))
Supported types (5.5) are:
You can not cast to varchar directly.
There is an open MySQL bug from 2008 which no-one seems to care about and is damn annoying