I am trying to return values but my select query returns wrong recordsI want to return only p2 s but the return values contain other itemsplease helpSelect admnoNameClassStream FROM science where class 39P239 and stream 39S39 AND Status IS NULL OR Status 3939ORDER BY ScienceNameadmnoNameClassStreamSTATUS2200054AGASHA ESTHERP2SNULL2200053MUHUMUZA DAVIDP2SNULL2200082MUNGUJAKISA ELIJAHP2SNULL2200056MUSINGUZI SHUHANP2SNULL2200078NAKATUDDE BRITINEP2SNULL220006

Use below querySELECT admnoNameClassStream FROM science WHERE class 39P239 and stream 39S39 AND ISNULLStatus3939 3939ORDER BY ScienceName

ISNULL in Where Clause does not return correct records in SQL Server

makumbi

I am trying to return values but my select query returns wrong records

I want to return only p2, s but the return values contain other items.

please help

Select admno,Name,Class,Stream FROM science where   class = 'P2' and stream ='S' AND (Status IS NULL) OR (Status ='')
ORDER BY Science.Name;

dharmend...

0 1

Use below query.

SELECT admno,Name,Class,Stream 
FROM science 
WHERE class = 'P2' and stream ='S' AND ISNULL(Status,'') = ''
ORDER BY Science.Name;

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html