Re: Collate

Thanks. I will probably use that as a work around. What I am wondering is that when I create a table in SQL server 2000 I use 'COLLATE SQL_Latin1_General_CP1_CI_AI' as column definition, which allows me to use the query "where source = 'tf000089'". Is there something similar in Oracle? I want to use the same query for both database platforms. To avoid using something like:
IF oracle
{ select *

    from table_name
    where UPPER(source) = 'TF000089'
}
else
{ select *

    from table_name
    where source = 'tf000089'
}

"Mark Townsend" <markbtownsend_at_attbi.com> wrote in message news:BA616400.8750%markbtownsend_at_attbi.com...
> in article hgV_9.114485$Ui4.3247743_at_news1.telusplanet.net, Jasminder Rai
at
> jasrai_at_canada.com wrote on 2/1/03 11:31 AM:
>
> > 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'.
>
> In that case, you will need to use the UPPER function in the query, and
> possibly create a functional index on UPPER(column)
>
Received on Sat Feb 01 2003 - 14:14:23 CST