title: how to remove ' from string
body: <p>Im trying to use the TRIM command in SQL to Remove special characters from a string. thing is i cant seem to figure out how to remove the ' character like how when people use it in their surname.</p>
  
  <p>e.g O'Reilly</p>
  
  <p>in order to remove a character i have to quote it, but how can put in quotes or identify the character ' when it is used for quoting.</p>