Posted by Mick White on 10/07/05 14:48

I have a column `cover` VARCHAR(10) that lists a cover charge in the
form of "$x.00", where x is the price of admission. I'd like to convert
the column to INT UNSIGNED, so that x(a number) is listed, not "$x.00".
Is this possible?
Thousands of entries are involved.
Mick

• Next in forum: Converting column types ( MySQL)
• Prev in forum: Converting column types ( MySQL)
• Thread view: Converting column types ( MySQL)

[Reply to this message]