Re: Date and Select problem

Hehe, this is almost identical to the post I submitted yesterday, entitled "SELECT 'foobar' = 0" There's a patch in that post, doesn't work for dates but should give an idea of what has to be done. The reason is that 'WWW' has to be converted to a date. And the conversion gives it a value of

Date and Select problem

My SQL query problem: I met a strange problem: For example, I have the following table: Mytable: No Name Date Project 1 Bob 2002-05-27Bob's project 2 John -00-00 John's project When I use "select * from