Share via

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

Lopez, Ahiezer 236 Reputation points
2023-09-07T17:33:47.6366667+00:00

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.
13,671 questions
0 comments
Accepted answer
  1. Bruce (SqlWork.com) 64,161 Reputation points
    2023-09-07T18:11:17.6133333+00:00

    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.