Hi!
On Mon, 9 Nov 1998, Wim Ceulemans wrote:
>
> select * from tablex where name = '%test%';
>
> When I want exactly the same but case insensitive, how do I do that? By
Convert all to uppercase. Something like
select * from tablex where UPPER(name) = '%TEST%';
Oleg.
----
Oleg Broytmann National Research Surgery Centre http://sun.med.ru/~phd/
Programmers don't die, they just GOSUB without RETURN.