Skip to content

Instantly share code, notes, and snippets.

@niisar

niisar/Delete last N characters from field in a SQL Server database.sql

Created September 13, 2014 04:56
Show Gist options
  • Save niisar/e44750bdebbf50cff55f to your computer and use it in GitHub Desktop.
Save niisar/e44750bdebbf50cff55f to your computer and use it in GitHub Desktop.
Download ZIP
Delete last N characters from field in a SQL Server database
Raw
Delete last N characters from field in a SQL Server database.sql
UPDATE mytable SET column=LEFT(column, LEN(column)-5)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment