help from Portugal

And why name a table with an accent egyy, anyway ?

Sorry my french.

Keep on keepin' on !

BR,

Aarni Ruuhimaeki

>>>
Huhlou,

The case is sensitive ?

I suggest you keep your tables and so forth in lower case.

All the time.

?

Leaves no wondering about the case in any case, unless you purpeuosly want it
?

Bets regards,

Aarni

On the old system I did the query:
SELECT * FROM contactos WHERE empresa_nome ILIKE ´%nestlé%´;

and it did work
O the new system it does not produce nothing!???

if I do
SELECT * FROM contactos WHERE empresa_nome ILIKE ´%NESTLÈ%´;
>>>
--
Aarni Ruuhimäki
Megative Tmi
KYMI.com

Pääsintie 26
45100 Kouvola
FINLAND

www.kymi.com / cfm.kymi.com

aarni(dot)ruuhimaki(at)kymi(dot)com / info(at)kymi(dot)com

+358-5-3755 035 / +358-50-4910 037
------------------------------------------------
Linux RedHat / KDE
Open Source: Millions of open minds can't be wrong