Escape each instance of single quote that is part of the data with another single quote. Also, your IN clause should enclose each search item in single quotes rather than a comma-separated list within single quotes:
Where Name IN
'CHILDREN''S ANES ASSOCS-CHOP',
'CHILDREN''S PSYCH ASSOC-CHOP',
'CHILDREN''S SURGICAL ASSOC-CHOP'
Editing: Forgot to plug a shallow SQL blog http://myshallowsqlblog.wordpress.com/escaping-single-quotes-in-sql/