Re: Upper & Lower case
Try where data matches '[Ma][Aa][Rr]'
Hope this helps.
Jarek B. wrote:
> 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.
--
*********************************************************************
* Pralay DUTTA GUPTA Phone : Voice 33 (0)1 49 40 67 07 *
* Service Informatique Fax 33 (0)1 49 40 66 79 *
* Universit' Paris 8 Email : Pralay.Dutta.Gupta@univ-paris8.fr *
*********************************************************************