User trying to update a column with data containing a quote. Example L'AZOTE. I know that this will do it:
Update table set column='L''AZOTE'.
What I was wondering if there was any other way to do this? If this is the only way, then application would have to check every update to see if there is an enclosed quote.