Posted by J.O. Aho on 10/12/29 11:38

dummie wrote:
> I've got brain free at the moment.
>
> But how do I convert an integer into a decimal ie
> 1 beomes 1.00
>
> This has come about because when I converted my Access database into
> MySQL it change all the decimal valvues into integers.
>

ALTER TABLE yourtablename MODIFY yourcolumnname FLOAT;



//Aho

[Back to original message]