Delete last N characters from field in a SQL Server database

Question

I have table of over 4 million rows and accidentally in one column there is more data than needed    For example instead of ABC there is ABC DEFG    How can I remove that N symbols using TSQL  Please note that I want to delete this characters from database  NOT just select substring  Thank you

User · Answer

You could do it using SUBSTRING   function   UPDATE table SET column   SUBSTRING column  0  LEN column    1 - N    Removes the last N characters from every row in the column

User · Answer

UPDATE mytable SET column LEFT column  LEN column -5    Removes the last 5 characters from the column  every row in mytable

User · Answer

I got the answer to my own question  ant this is   select reverse stuff reverse  a b c d     1  N         Where N is the number of characters to remove  This avoids to write the complex column string twice

User · Answer

This should do it  removing characters from the left by one or however many needed   lEFT columnX LEN columnX  - 1  AS NewColumnName

[sql-server] Delete last N characters from field in a SQL Server database

Examples related to sql-server