A
A
AlexCruel2020-10-05 21:06:40
SQL
AlexCruel, 2020-10-05 21:06:40

Avoid closing quotes in a query?

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 the question

In order to leave comments, you need to log in

1 answer(s)
Z
zexer, 2020-10-05
@zexer

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

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question