asked
How to update the last 3 characters in a column in a table
Hello there I am trying to update the last 3 characters in a column (Empname) in a table (Employees) EmpID Empname 1 Leo Llc 2 George Llc so that it look like the following: Leo, LLC George, LLC I am using the following query but it is not producing the desired results UPDATE Employees SET empname= SUBSTRING(empname,4,3)+ ', LLC' WHERE RIGHT(empname,3) = 'Llc' Thanks in advance for the help Rio
UPDATE employees SET employees.empname = LEFT(employees.empname, CHARINDEX(' LLC', employees.empname, 1)-1) + ', LLC' WHERE RIGHT(employees.empname, 3)='Llc'
Thank you for your answer It worked great ,Thank you for your answer. It worked great Rio
15 People are following this question.
