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
Mad Myche
SSCommitted
Points: 1593
More actions
July 25, 2011 at 9:04 am
#1357841
Ninja's_RGR'us (7/24/2011)All we said is that it can delete the wrong data with replace. Left is clear as day. Whack the last 3 characters and most importantly, it cannot fail.
Ninja's_RGR'us (7/24/2011)
As long as there are a minimum of 3 characters in the field