Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Collate
Thanks for the reply. To answer your question about how I want to use it.
I want to be able to search in a where clause for example.
where source = 'tf000098'
and the server does a case-insensitive search and returns those rows that are stored in the database as 'TF000098' or 'tf000098'.
"Mark Townsend" <markbtownsend_at_attbi.com> wrote in message
news:BA6157DA.8688%markbtownsend_at_attbi.com...
> in article %zU_9.114461$Ui4.3243632_at_news1.telusplanet.net, Jasminder Rai
at
> jasrai_at_canada.com wrote on 2/1/03 10:44 AM:
>
> > Like in MS-SQL Server 2000, is there an equivalent of COLLATE in Oracle
> >
> > Thank you,
> >
> > Jasminder
> >
> >
> Without a reference to how you want to use it, it's a bit difficult to be
> exact, but have a look at NLS_SORT and NLSSORT in the doc -
>
http://tahiti.oracle.com/pls/db92/db92.drilldown?levelnum=2&toplevel=a96540&
>
method=FULL&chapters=0&book=&wildcards=1&preference=&expand_all=&verb=&word=
> nls_sort#a96540
>
Received on Sat Feb 01 2003 - 13:31:25 CST
![]() |
![]() |