I need to be able to remove a trailing period from all values in a column.
table company(id, name, address)
some values in the name column are stored with a trailing period, such as 'ACME Inc.' or 'MyCompany Inc.'.
I need to comb through each record and remove the . (period) at the end of the name field.
Any suggestions? This is somewhat urgent, hence the 500 points reward.