Update first 2 characters in SQL

By Cornel Caba Software 28 February 2022

Advertisements by Google

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

Advertisements by Google

Cornel Caba / About Author

Please Enable JavaScript in your Browser to Visit this Site.

#mdp-deblocker-js-disabled { position: fixed; top: 0; left: 0; height: 100%; width: 100%; z-index: 999999; text-align: center; background-color: #FFFFFF; color: #000000; font-size: 40px; display: flex; align-items: center; justify-content: center; }

%d bloggers like this:

Update first 2 characters in SQL

Like this:

Leave a comment Cancel reply

Update first 2 characters in SQL

Share this:

Like this:

Related Posts

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Share this:

Like this:

Leave a comment Cancel reply