Delete last N characters from field in a SQL Server database
UPDATE mytable SET column=LEFT(column, LEN(column)-5)