Why does not the sql query?

There is a table of applications I want to run the query which will define the id of the application status , but when you run the query nothing appears. Query:
select Id_bids from Bids where Bids.Status = 'Awaiting approval'

Table columns:

CREATE TABLE [dbo].[Bids] (
 [Id_bids] INT IDENTITY (1, 1) NOT NULL,
 [Username] NVARCHAR (50) NULL,
 [Command] NVARCHAR (50) NULL,
 [Ship name] NVARCHAR (50) NULL,
 [Release date] NVARCHAR (50) NULL,
 [Return date] NVARCHAR (50) NULL,
 [Name of member команды1] NVARCHAR (50) NULL,
 [Address1] NVARCHAR (50) NULL,
 [Должность1] NVARCHAR (50) NULL,
 [Name of member команды2] NVARCHAR (50) NULL,
 [Address2] NVARCHAR (50) NULL,
 [Должность2] NVARCHAR (50) NULL,
 [Name of member команды3] NVARCHAR (50) NULL,
 [Адрес3] NVARCHAR (50) NULL,
 [Должность3] NVARCHAR (50) NULL,
 [Name of member команды4] NVARCHAR (50) NULL,
 [Адрес4] NVARCHAR (50) NULL,
 [Должность4] NVARCHAR (50) NULL,
 [Name of member команды5] NVARCHAR (50) NULL,
 [Адрес5] NVARCHAR (50) NULL,
 [Должность5] NVARCHAR (50) NULL,
 [Status] NVARCHAR (70) NULL,
 CONSTRAINT [PK_Bids] PRIMARY KEY CLUSTERED ([Id_bids] ASC)
);

The data in SSMS

5dfb85e55d25f568063744.png
April 3rd 20 at 18:43
2 answers
April 3rd 20 at 18:45
Solution
Because we need UNICODE. You have a field of NVARCHAR.
select Id_bids from Bids where Bids.Status = ' N 'Awaiting approval'
Strange, but I have no N's works - verner.Legro commented on April 3rd 20 at 18:48
@verner.Legro, Probably the query designer itself is framed by the type field. - kayleigh commented on April 3rd 20 at 18:51
Designers do not use. Hands only write requests - verner.Legro commented on April 3rd 20 at 18:54
depends on the encoding on the server. If char/varchar with Cyrillic support, it should work without N. - Jarrett_Denesik commented on April 3rd 20 at 18:57
April 3rd 20 at 18:47
Have created your table, have data.
The query works!

Possible cause:
in the Status field you have in the table the phrase 'Awaiting confirmation' contains an extra space at the end.
For the test - copy the contents of the Status field from one table and insert it into the query
Tried to insert value from a table generates id _ bids and zero indices - domenica88 commented on April 3rd 20 at 18:50

Find more questions by tags Transact-SQLSQL Server