Mysql cast to decimal give 99.9
<p>I got a varchar field say the value as 174 but when I <code>cast(field as decimal(3,1))</code> it gives me always 99.9? How can I cast or convert it to be 17.4? Or must I change at source level the input to be input in decimal itself?</p>