RE: A date problem

Since it's a date field, it's a date comparison and the date that you specify ('WWW') gets parsed by the optimizer as being the date '-00-00' since it can't find any valid date information. This is different from if it was to convert the date to a string and do a string comparison, which is w

A date problem

Hi, I also have a date problem: My SQL query 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 query &quo