denny simon

denny simon

  • NA
  • 57
  • 0

how to query if the kriterial is null

Mar 25 2010 12:50 AM

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

Answers (3)