Re: Upper & Lower case
Jarek B. schrieb:
> I don't won't to differentiate in online upper and lower case. How to do it?
>
> f.e.
> data
> ------
> mar
> Mar
> MAr
> MAR
> maR
>
> querry:
> select data from table where data = "mar";> result:
>
> data
> ------
> mar
>
> I need result:
>
> data
> ------
> mar
> Mar
> MAr
> MAR
> maR
>
> Thanks,
>
> Jarek B.
Hi Jarek,
use the UPPER-function from www.iiug.org like this :
select data from table where UPPER(data) = "MAR";
Bye
Dirk Niemeier