String

Surround values of type String with single quotation marks. For example:

SELECT SI_ID, SI_NAME WHERE SI_NAME = 'Jonathan'

To search for a string that includes an apostrophe literal, use the character twice. For example, if you are trying to do a pattern match for "Jonathan's folder", you would use two apostrophes:

SELECT SI_ID, SI_NAME WHERE SI_NAME LIKE 'Jonathan''s%'