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
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