Share via

How do I setup a query while looking for a record with an apostrophe in it?

Lopez, Ahiezer 236 Reputation points
Sep 7, 2023, 5:33 PM

How do I setup a query while looking for a record with an apostrophe in it?

User's image

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,494 questions
0 comments
Accepted answer
  1. Bruce (SqlWork.com) 73,661 Reputation points
    Sep 7, 2023, 6:11 PM

    You just quote it with a ‘

    select *
FROM tbImacoonew
WHERE [COMPANY NAME] like 'Andersen''s Industries Inc'
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.