Simple question about updating a table field

I have a numeric table field, named CREDIT. How can I add a number (+50) to that field for all the table record ? is this correct? UPDATE ThisTable SET CREDIT=CREDIT+50 Please help, Thanks __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard

Re: Simple question about updating a table field

Yes it is correct, but please don't hijack someone else's thread. Admin-Stress wrote: I have a numeric table field, named CREDIT. How can I add a number (+50) to that field for all the table record ? is this correct UPDATE ThisTable SET CREDIT=CREDIT+50 Please help, Thanks