how to query if the kriterial is null

Question

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

Amit Choudhary · 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.

Sailaja Y · Answer

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

Hirendra Sisodiya · Answer

hello Denny use this query: select UserNumber from TblTest where UserID is null thanks Please mark as answere if you like my answere