MySQL (well, actually MariaDB via HeidiSQL IDE)

For some reason, I'm having a problem getting a field cast as a varchar in
my sql.  I'm trying this:

select CAST('test' as varchar(255));

...and it fails saying I have an error in syntax.  I can do this just fine:

select CAST('test' as char(255));

WTF?!?!?  On more tests, it seems that I can't get it to cast to VARCHAR
or FLOAT types.

Is there something obvious here that I'm missing?

tia,
--Mike



_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: 
http://leafe.com/archives/byMID/profox/223caa2c7591c24a60abeded81de39e5.squir...@webmail.dssco.net
** All postings, unless explicitly stated otherwise, are the opinions of the 
author, and do not constitute legal or medical advice. This statement is added 
to the messages for those lawyers who are too stupid to see the obvious.

Reply via email to