Problem with SQL Server Select Replace()

Question

I am successfully executing the following query in SQL Server 2008 built into VS2008:

SELECT REPLACE(image32, 'img', 'images/Products')
FROM Product

but when I do a select * from product query, I am given the old results. Whats going on? Why isnt my data being updated?

Did I just answer my question? Do I need to throw in an Update statement as well? If so, can you help me, my sql nerd powers are not that great yet.

Andomar · Accepted Answer · 2009-11-01 18:44:40Z

2

Here's an example update statement:

UPDATE Product
SET image32 = replace(image32, 'img', 'images/Products')

If 'img' was a directory, better search for '/img/' and replace it with '/images/Products/'. You never know what filenames might contain img.

answered Nov 1, 2009 at 18:44

Andomar

239k55 gold badges387 silver badges412 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

NoDinero Over a year ago

Wow I still have a long way to go to becoming a SQL Query master. Many thanks.

Dave Markle · Accepted Answer · 2009-11-01 18:33:52Z

1

Yes, you did just answer your question. You need to UPDATE if you want your data updated. Table data only gets changed when you INSERT, UPDATE, or DELETE.

answered Nov 1, 2009 at 18:33

Dave Markle

98.3k20 gold badges152 silver badges172 bronze badges

1 Comment

NoDinero Over a year ago

Ok, cool. Im gonna give this a shot on my own. Thanks. BTW - You guys are super quick!! :)

Collectives™ on Stack Overflow

Problem with SQL Server Select Replace()

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related