Saturday, 29 December 2018

Update First Multiple Character In SQL Server

BEGIN
UPDATE dbo.TABLENAME
SET FORM_CODE = 'M11' + SUBSTRING(form_code,4,3)
WHERE LEFT(FORM_CODE,3) = 'M10'  
END

No comments:

Post a Comment