• The table script u gave in ur first post defines Quantity as Integer.

    I modified the column by running

    alter table reorderS alter column Quantity decimal(10,2), you can increase the precision (here 2) or use float data type as well...

    I also updated the quantity column

    update reorders set quantity=quantity*6.123

    and the same cursor displays records perfectly.



    Pradeep Singh