Problem with sql function LOWER

From: "Th Templ" <templ_th(at)hotmail(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Problem with sql function LOWER
Date: 2002-07-03 13:50:28
Message-ID: F170q0XVy6REY3U8xT600006a26@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hello,

I try to make this sql request but it returns nothing...

Tables personne
Nom | Prenom
----------|------------
Test | Test1

SELECT Nom,Prenom from personne where LOWER(personne.personne_nom)='test';

(0 row)

Is this syntax not correct?
Thanks for your help.
Templth

_________________________________________________________________
Join the worlds largest e-mail service with MSN Hotmail.
http://www.hotmail.com

Browse pgsql-jdbc by date

  From Date Subject
Next Message Steve Brett 2002-07-03 14:12:52 Re: Problem with sql function LOWER
Previous Message tony 2002-07-03 13:19:07 Re: Problem with accentuated characters