case insensitive selects



Hello,
does DBD::CSV supports the following select clause?

select * from table where upper (col1) like '%ab%';

I'd like to make case insensitive queries but from docs it seems
it's not allowed.

Thanks Radek

.



Relevant Pages

  • Re: LEFT JOIN on very large tables
    ... Use the where clause for pagination, you'll find your system responds a ... lot quicker;-) ... Prev by Date: ...
    (comp.lang.php)
  • Re: Open a query getting 0 record
    ... a where clause that evaluates to false is the only way ... Brian Bushay (TeamB) ... Prev by Date: ...
    (borland.public.delphi.database.ado)
  • Re: Weird import behavior
    ... statement in the except clause the program runs fine. ... the exception hander never gets executed! ... Any explanation? ... Prev by Date: ...
    (comp.lang.python)
  • Re: Korzh Simple Query question
    ... it doesn't add the table to the FROM clause. ... I still haven't heard back from Korzh. ... Tim Sullivan ... Prev by Date: ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: How can I use N different where clauses in a single update statement?
    ... value is 'ABCDEF', and you update it to the same value, ... won't that still be an update that gets processed by Oracle? ... What I'm really looking for is how to vary the WHERE clause for each ... Prev by Date: ...
    (comp.databases.oracle.misc)