No. SQLServer != Oracle. They are very very different beasts and operate
very differently. No really they do. For example, it is rare in Oracle to
create temp tables and readers don't block writers and writers don't block
readers. Many many differences.
Jim
"Jasminder Rai" <jasrai_at_canada.com> wrote in message
news:zUV_9.114492$Ui4.3251856_at_news1.telusplanet.net...
> 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:33:59 CST
