In Azure Cognitive Search, the simple query syntax invokes the default query parser for full text search. The parser is fast and handles common scenarios, including full text search, filtered and ...
What you want to do is insert the data in the database with the ' replaced with '' . This escapes the apostrophe and won't mess up the query.
# you may not use this file except in compliance with the License. # You may obtain a copy of the License at # http://www.apache.org/licenses/LICENSE-2.0 ...