Browsing: sql

DECLARE @ReplaceString CHAR(2) SET @ReplaceString = ‘C:’ UPDATE [DATABASENAME].[dbo].[TABLENAME] SET TABLENAME= REPLACE(TABLENAME, LEFT(TABLENAME, 2),@ReplaceString) WHERE LEFT(TABLENAME,2) = ‘P:’