I'm trying to use the Data Defined symbology in QGIS ver 2.2. Some of my data has single quotes/apostrophes.

Since the string must use single quotes, is there an escape option I can use for the field calculator or for the data defined settings field?


So, I'm trying to use something like this:

    CASE
    WHEN "NAME" = 'WILSON'S' THEN '0,75,224'
    END

How do you build an expression around a string that may have a single quote or apostrophe?

Thanks.
QGIS Valmiera 2.2
Windows 7 - 32 bit