RE: FN-FORUM: Oracle - Sensitive Bugger

date posted 7th August 2003 14:52

SQL is.. By default case-insensitive..=20

Have a look at
http://vyaskn.tripod.com/case_sensitive_search_in_sql_server.htm

For a few tips/hints/tricks that might be of use to you..

Cheers..

Craig

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
[EMAIL REMOVED]
Sent: Thursday, August 07, 2003 3:12 PM
To: FN-FORUM / [EMAIL REMOVED]
Subject: FN-FORUM: Oracle - Sensitive Bugger



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

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
fido.net are pleased to sponsor these Freelancers messages. For all
your web hosting needs check out http://www.fido.net/ with hosting
packages starting from just =A346.95 a year including VAT. Free 0871
Fax2Email numbers also available online! http://www.fido.net/ - the
internet made simple! - 0800 1072 666

To advertise here: http://www.freelancers.net/advertising.html