Case sensitive "like"

Hi

Hopefully someone can help

consider "where name like 'fred' . On Access this is case insensitive and works well. On Oracle it doesn't.
I want to avoid using "where lower(name) like 'fred'" Is there any way of configuring oracle to always ignore case sensitive comparisons.

thanks in anticipation.

gerard heathcote Received on Wed May 05 1999 - 17:48:04 CDT