Avoid closing quotes in a query?

Question

SQL

Full name has a patronymic with an apostrophe, so there is a closing => error.
Is there another frame? How to avoid the mistake?
Thank you!

SELECT [СтудНомер] FROM [Студенты] WHERE [ФИО_Студ] = 'Iванова Юр'еўна'

Answer 1

Double quotes?
Learn how to escape quotes in sql, there are plenty of examples on google.