quick sql question

[AntiFreze]

So I'm pretty sure it will be this when I run it:

UPDATE [tabl_name]
SET Data = replace(Data,'href=\"/','href=\"../');

how do I write this as a SELECT query so I can test the results before I run it? Simple I know... it's been a long day and google is failing me atm.

I appreciate the help.

 

[WannaFly]

select replace(Data,'href=\"/','href=\"../') from tabl_name

 

[AntiFreze]

yeah... hehe.... thank you much