Posted by Joel on 11/02/05 21:41

Hi,
I recently converted data and discovered that when the date wasn't formatted
properly '01/01/001' (I think) I was unable to find the record using
Sql i.e 'Select * from table where order_#=100' . However, using utilities
(Navicat) I was able to find the record. Any reason?

PS In a way I was happy because it helped me determine how I got the bad
data!

PPS The DB is MySql

[Back to original message]