How to pass a special character in an SQL statement 1

[benmillus]

For example, "UPDATE tableName SET [tableName].fieldMessage = 'OTC's Not Covered' WHERE [tableName].fieldNameID1='0403REJ' and [tableName].fieldNameID2='0008';"

Need to update "fieldMessage" with the value "OTC's Not Covered". But the value contains the ' character and SQL does not interpet it as part of the value.

Any ideas?

 

[swampBoogie]

UPDATE tableName 
   SET fieldMessage = 'OTC''s Not Covered' 
 WHERE fieldNameID1='0403REJ' 
   and fieldNameID2='0008'

 

[benmillus]

Thank you swampBoogie this worked.