Wednesday, March 21, 2012

Need some help with check contraint in SQL2005

Hi,

I have this table which contains 2 datetime fields called Startdate & enddate

Startdate cannot contain NULL
Enddate can because it can be a single day event or a period.

If enddate is not null it must be later than startdate
i created this checkconstraint

enddate > startdate

But i also fires when enddate = NULL

Someone knows howto do this?

Cheers Wimenddate > startdate
OR
enddate IS NULL|||Thanx for your reply.

But enddate could be NULL when NOTNULL it should be later then Startdate|||Your point being? :)|||Sorry my bad, calendar control gives me 1-1-1980 instead of NUll

Thanx for ur help!!
CHeers Wimsql

No comments:

Post a Comment