executing null values records

Posted by jjj on Stack Overflow See other posts from Stack Overflow or by jjj
Published on 2010-03-16T07:51:29Z Indexed on 2010/03/16 7:56 UTC
Read the original article Hit count: 249

Filed under:
|

i am trying to execute the records that have TotalTime null value from the table NewTimeAttendance...TotalTime datatype nchar(10)

select * from newtimeattendance where TotalTime =  'NULL'

....nothing

select * from newtimeattendance where TotalTime =  'null'

....nothing

select * from newtimeattendance where TotalTime =  'Null'

....nothing

select * from newtimeattendance where TotalTime =  null

....nothing

select * from newtimeattendance where TotalTime =  Null

....nothing

select * from newtimeattendance where TotalTime =  NULL

....nothing

when i select the whole table i can see that there is some NULL TotalTime values..!!

it is small select statment ..why doesn't it work ? is there a way (special way ) to execute the 'NULL' with nchar type ?!

thanks in advance

© Stack Overflow or respective owner

Related posts about sql

Related posts about nullvalue