Why does the query not show the name, although it is in the T-SQL database?

Question

Transact SQL

Searches only for numeric values, not for text values. The type is nvarchar.
For example, I'm trying to find a person with the surname Gordeev, I create a query, but it does not find anything, despite the fact that this surname is in the table.
I tried names in English. language to look for, but the same thing.
Like, In, = the same

Answer 1

It turned out that you need to put N before the name
where surname N'Gordeev'