TRIMing single quote from the String

RTRIM(LTRIM(Input_String,CHR(39)),CHR(39))

Note: Here CHR(39) will return the ASCII character which is ' (single quote)