I don't know if its a lack of understanding about SQL, or of SQL::Statement/ DBD::CSV, but I have a numeric field "datasize", if I do
select * from my_table I get a,0 b,0 c,0 When I do: select * from my_table where datasize = '0' I get nothing, it doesn't match. Weird. But if I do: select * from my_table where datasize LIKE '%0%' I do get matches. I'm baffled. I tried datasize = ' 0' and datasize = '0 ' and other variants. I just doesn't match without LIKE. Suggestions? What's wrong? I'm hacking around it by change = to LIKE, but this is strange. Thanks! Sam -- Sam Roberts <[EMAIL PROTECTED]>
