FN-FORUM: Oracle - Sensitive Bugger

date posted 7th August 2003 14:44

Afternoon all,

Oracle it seems is a bit fussy when it comes to character case: does anyone
know how to 'turn-off' its case-sensitive tendancies, i.e.:

SELECT firstname, lastname from EmployeeTab WHERE lastname like 'stOKeS%';

Would return:

Robert Stokes

Thanks