var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Data Type Conversion
I want to know how I can convert int datatype to varchar how I do the same.
query is : select convert(DesignationCode,varchar(200) from employee;
above query is showing error
But when i used char(200) instead of varchar it is working fine.
Kindly guide me how to use varchar in datatype conversion.
try CAST(DesignationCode AS CHAR)
Has the missing paren got anything to do with the error?
SELECT Convert(DesignationCode, varchar(200)
check da manual, george
correct syntax, let me show u it
oops is right
what forum are you in? did you check da mysql manual???
dev.mysql will never load from this location, so no, I did not.
I had gone through the mysql manual after that only i posted my query in the forum. As i didn't find any solution for converting int datatype to varchar.
okay, to be somewhat more helpful...
next time you're on a computer that can access dev.mysql.com, george, download one of the CHM files, and copy it to a floppy (or a usb memory stick or whatever) and take that with you
the CHM is a ~lot~ easier to search and browse than going to dev.mysql.com anyway
I should also point out that MySQL will automatically convert numbers to characters when required ie select concat( 1234,"a") will produce "1234a".