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

[Back to original message]