Filter no null rows using WHERE clause

Question

SELECT        BC_ID, Procedure_Description, Test_result, Normal_Values
FROM            tbl_BC
WHERE        (NOT (Test_result LIKE '@Test_result = %'))

Hello.

I want to filter all not null in Test_result row, but with the code above all records in the datagridview will hide.

If you only want to display all rows that are not null you can use where Test_result is not null — schudel
– schudel, Commented Apr 2, 2016 at 7:58

Dai · Accepted Answer · 2016-04-02 00:51:14Z

1

Your question is unclear, but I think you want to ensure that NULL values are not included in your results.

Use IS NOT NULL to filter NULL values in T-SQL:

SELECT
    BC_ID,
    Procedure_Description,
    Test_Result,
    Normal_Values
FROM
    tbl_BC
WHERE
    Test_Result NOT LIKE @Test_Result + '%'
    AND
    TestResult IS NOT NULL

answered Apr 2, 2016 at 0:51

Dai

158k31 gold badges314 silver badges438 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dai Over a year ago

@JaphetCompendioBatucan Can you post some example input and desired output data in your original question? Thanks!

Collectives™ on Stack Overflow

Filter no null rows using WHERE clause

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related