How can I update some of columns:
UPDATE Product
SET Title = REPLACE(Title , 'mn%', 'za%')
WHERE (Title LIKE N'mn%')
Consider data of one column is mnfmnd and must be changed to zafmnd
-
is it always the first two characters?S3S– S3S2016-08-25 19:50:08 +00:00Commented Aug 25, 2016 at 19:50
-
@scsimon yes, it's always first charactersMohi– Mohi2016-08-25 19:51:28 +00:00Commented Aug 25, 2016 at 19:51
-
2Your query is trying to replace all instances of the string literal mn% in Title. I don't think that is what you want. This seems like a great place to use STUFFSean Lange– Sean Lange2016-08-25 19:52:42 +00:00Commented Aug 25, 2016 at 19:52
-
@SeanLange seems like a great suggestion.xQbert– xQbert2016-08-25 19:54:22 +00:00Commented Aug 25, 2016 at 19:54
-
@SeanLange it seems to be good, I checking itMohi– Mohi2016-08-25 19:54:37 +00:00Commented Aug 25, 2016 at 19:54
|
Show 1 more comment
4 Answers
I would be inclined to use stuff() for this purpose:
update product
set title = stuff(title, 1, 2, 'za')
where title like 'mn%';
1 Comment
Mohi
Thank you , it works :), but sorry I must to choose one answer
create table #t (title varchar(16))
insert into #t (title) values ('abcdef'),('defghi')
UPDATE #t
SET title = stuff(Title , 1,2,'za')
WHERE (Title LIKE N'ab%')
select * from #t
1 Comment
Mohi
Thank you , it works :), but sorry I must to choose one answer
use right and + instead... the % is not a wild card in the replace.
UPDATE Product
SET Title = 'za'+right(len(title)-2)
WHERE (Title LIKE N'mn%')
Incase stuff isn't in your version of SQL server...
