Can someone show me the case specifications for SQL? I think that unless quoted table names are case insensitive, so
SELECT * FROM FOO; equals select * from foo; but does not equal SELECT * from "Foo"; IMHO, when selecting from files, unquoted table names should match case-insensitive, so a file named "Foo" should match all three, but file named "foo" should match the first two statements. If I am right, I got the unquoted working in my current DBD::File, and I'm working on the second part (it currently matches too often) -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using & porting perl 5.6.2, 5.8.x, 5.10.x, 5.11.x on HP-UX 10.20, 11.00, 11.11, 11.23, and 11.31, OpenSuSE 10.3, 11.0, and 11.1, AIX 5.2 and 5.3. http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/