mysql - SQL CAST(int as varchar) throws error -

good evening,

i'm trying convert int varchar using cast() function gives me following error:

syntax error, unexpected varchar 

and code

cast(p2v varchar) 

and tried

cast(p2v varchar(max)) 

i got same problem when try using convert()

it must char, not varchar

the type result can 1 of following values:

• binary[(n)]
• char[(n)]
• date
• datetime
• decimal[(m[,d])]
• signed [integer]
• time
• unsigned [integer]

from http://dev.mysql.com/doc/refman/5.5/en/cast-functions.html#function_cast