Skip to Content
0
Jan 10, 2023 at 01:02 PM

Query with IS NOT NULL not working correctly

76 Views

Hi,

I have a problem with the query.

SELECT 
T0.[DocDate],
T0.[DocNum], 
T0.[NumAtCard],  
T0.[CardCode], 
T0.[CardName], 
T0.[DocStatus] 

FROM OINV T0 

WHERE 
T0.[DocStatus] = 'O' 
AND  
T0.[BlockDunn] = 'N'
AND
T0.[NumAtCard] IS NOT NULL

The query works, but the result is not correct.

image.png

It still shows invoices where the field T0.[NumAtCard] is empty. When I open one of these invoices this field is empty.

When I put my cursor in the field there is also not a space of something.

What is wrong here?

Attachments

image.png (34.7 kB)