Re: Case sensitive

In article <a9p1om$oku$1_at_ail.sri.ucl.ac.be>, berdii_at_techemail.com says...
> select * from test where name like "D%"
>
>

Use
  select * from test where lower(name) like "d%"

This will of course ignore any indexes on the name column, but you could create a function based index on name as described in the previous reply. Received on Fri Apr 19 2002 - 07:36:37 CDT