need to update .0 in database field

hi there

i am in difficult situation pls help me.. i have 100 data in my sql table. i need to add ".0" in all the data. how can i do that? pls help

e.g present data in field: 15

update to 15.0

thanks in advance

 

In mysql:

update your_table set rec=concat(rec,'.0');

Never tried that, tell me if ti works

 

thanks it works like charm...

 

Thanks helped me aswell