I'm trying perform a case-insensitive test for a name. These are stored
like Association of ..., and I want to convert both the filter and the
test data to lower- (or upper-) case. Why doesn't this work: ?
SELECT *
FROM [Organisation Membership]
WHERE lower(organisation) LIKE
---
-Original Message-
From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 14:34
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Using functions in SELECT statements
I'm trying perform a case-insensitive test for a name. These are stored
like
software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
---
-Original Message-
From: Robin S McKenzie [mailto:[EMAIL PROTECTED]]
Sent: 02 May 2002 14:34
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Using functions i
- Original Message -
From: Robin S McKenzie [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, May 02, 2002 3:11 PM
Subject: Re: [PHP-DB] Using functions in SELECT statements
If only it were that simple - sorry, that was a copying error...
It gives the error undefined function
: [PHP-DB] Using functions in SELECT statements
If only it were that simple - sorry, that was a copying error...
It gives the error undefined function: lower
R
Robin McKenzie Department of Mechanical Engineering University of Bristol
e:[EMAIL PROTECTED] e:[EMAIL PROTECTED] m:+44(0)7970 058712