I tried to update kavi as sangeetha and its corresponding Mark value 50 as 100 in my mdb database table named a
using this comment
UPDATE a SET Names='SANGEETHA', Marks='100' WHERE Names='KAVI'
But kavi is uptated as sang and 100 is updated as 10.ie more than the previous size is not updated.
kavi