DECLARE @ReplaceString CHAR(2) SET @ReplaceString = 'C:' UPDATE [DATABASENAME].[dbo].[TABLENAME] SET TABLENAME= REPLACE(TABLENAME, LEFT(TABLENAME, 2),@ReplaceString) WHERE LEFT(TABLENAME,2) = 'P:'
Your email address will not be published. Required fields are marked *
Comment *
Name *
Email *
Website
Save my name, email, and website in this browser for the next time I comment.