[vox-tech] MySQL: convert char to string

Dylan Beaudette vox-tech@lists.lugod.org
Wed, 26 May 2004 11:50:24 -0700 (PDT)


Hi everyone!

quick MySQL question...

is there any clean way (in the SQL itself) to convert an integer to a
string in MySQL prior to 4.1?

for example: select to_char(int_column) as this_used_to_be_an_int

it might be obvious from the above example that i am porting some Oracle
PL/SQL to MySQL....

any ideas?

thanks in advance!

Dylan