Home Forums SQL Server 2005 T-SQL (SS2K5) How to Delete Right 3 Characters from a string RE: How to Delete Right 3 Characters from a string
//Ravi
SSCrazy
Points: 2612
More actions
January 22, 2010 at 10:17 am
#1107443
Lynn,
Thanks. It worked. Here was the solution.
SELECT left (column_name, len(column_name) -3) FROM Table_Name
------------🙂