Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 re:Conditional where clause

Author  Topic 

collie
Constraint Violating Yak Guru

400 Posts

Posted - 2005-01-18 : 03:41:13
Thanks for the reply.
I tried your example but for some reason once i add that condition i don't get any results in the resultset and when I delete the conditon i do get results. I also checked to see if there are students with rdate> or < then the date specified and there are.
   

- Advertisement -