|
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
Navigation:
[Reply to this message]
|