Timestamp field in sybase.

[johnvai]

I want to select all the records that have Date2 field as null and the Date2 field is timestamp data type and allownull.
can you give me an sql statement wich shows me all the records that have date2 field as null??

select date1 from AAA where [Len(date2)=0 or Val(date2)=0 or isnull(date2) =true or isempty(date2)=true] are not working from VB.

Thanks

 

[VDavid]

select date1 from AAA where (date2 is null)

hope this helps

David

 

[johnvai]

Thanks for the tip.
It works.