SQL - Remove ' characters in strings

Select Replace(myfield,'''','')  -- Removes ' characters

Select myfield + '''' as MyNewField  --Adds a single ' character to the end of the string