I have data in one of my columns in a table that I would like to remove via a SQL update statement. In all cases, the data that I want to remove is the same 3 characters at the end of the varchar field. How would I structure the SQL statement?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!