Loading

how to query if the kriterial is null

denny simon

16y2.9kSQL

with intention to update the row with UserID=NULL
(there are many rows with UserID haven't fill yet )

I try to query with the statement :

select UserNumber from TblTest where UserID='NULL'

the result give me 0 rows

what wrong with my query ?

tq

denny

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Choudhary16y ago
Accepted answer
hi friend,

while dealing with null valued in where clause user 'IS NULL' operator and 'IS NOT NULL' operator to check the values are null or not.

So according to this your query will be like this:

SELECT UserNumber FROM TblTest where UserID IS NULL

Please mark as answer if it helps.
0
Sailaja Y16y ago
Hi Denny,
Try to use this query it works.
SELECT UserNumber FROM TblTest where UserID IS NULL

Mark it as answer, if this helps.

Regards,
0
Hirendra Sisodiya16y ago

hello Denny
use this query:
select UserNumber from TblTest where UserID is null

thanks
Please mark as answere if you like my answere
0