John Brooking wrote: > However, I'm experiencing some limitations and odd > behavior with DBD::CSV, which I don't see addressed in > the perldoc. The problem I'm currently struggling with > concerns the comparison operators used on text fields.
That kind of comparison was not supported in the XS version of SQL::Statement (the module that does that actual SQL for DBD::CSV). Upgrade to the pure perl SQL statement (version 1.x and higher) and the problem should go away. You can read about the two versions of SQL::Statement (including this issue of alphabetic comparison) and learn how to get the new one at: http://www.vpservices.com/jeff/programs/sql-compare.html -- Jeff
