Re: Problem with sql function LOWER

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

Steve

> -----Original Message-----
> From: Th Templ [mailto:templ_th(at)hotmail(dot)com]
> Sent: 03 July 2002 14:50
> To: pgsql-jdbc(at)postgresql(dot)org
> Subject: [JDBC] Problem with sql function LOWER
>
>
> 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 world's largest e-mail service with MSN Hotmail.
> http://www.hotmail.com
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to
> majordomo(at)postgresql(dot)org)
>
>