I apologize in advance, my wording in the original post was wrong.

the table is - Integration.Encounter

the column is - Facility

specific string value I am trying to find in the facility...