How do I use replace to remove single quotes and commas?
Posted on 2007-03-26
I have a column called VirtualTours in which I want to remove single quotes and commas. I am trying to use the replace function. See below (incorrect) example.
BEGIN TRAN; UPDATE listings
SET [virtualtours] = replace('''', '', [virtualtours]);
WHERE LEN(VirtualTours) > 1; ROLLBACK;
For example, I have 'vt', and I want it to return vt.