quick sql question

AntiFreze

Golden Member
Oct 23, 2007
1,459
0
0
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.