Problem with a single quotation mark in a string

Can't find a description of this problem anywhere... I have a script written in VBScript. I am trying to see if a string contains a substring that has a single quotation mark in it: String =...