xxxx

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

declare @tbl as table(
    [str] varchar(max)
);

insert into @tbl values
('C:/Program/Optima'),
('C:/Program/Optima/genrap'),
('C:/Program/Optima/migrator'),
('C:/Program/Optima/biuro');

SELECT CASE
        WHEN LEFT([str], 1) = 'C' 
        THEN 'D' + SUBSTRING([str], 2, LEN([str]) - 2)  
        ELSE [str] END AS [updated_str]
FROM @tbl;

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results