Re: Collate

From: Jasminder Rai <jasrai_at_canada.com>
Date: Sat, 01 Feb 2003 19:31:25 GMT
Message-ID: <hgV_9.114485$Ui4.3247743@news1.telusplanet.net>

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