Case Sensitive ?

We are going to migrate an Oracle Database to SQL Server
2000 by a contractor.
The data in the Oracle Database is case sensitive as it is
a legay system.
When we migrate to SQL Server 2000, we will use reporting
tools via ODBC connection to the database. We would like
to know can the new system be case insensitive during
query, especially during the wildcard search.
ThanksWhat you want to read up on is "collations" in SQL Server. You define a coll
ation at install, it
goes for the system databases, and is default for user databases. When you c
reate a user db, you can
override system default. When you create a table, you can define collation f
or each column (default
is database default).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:09f301c52aae$2afc96c0$a501280a@.phx.gbl...
> We are going to migrate an Oracle Database to SQL Server
> 2000 by a contractor.
> The data in the Oracle Database is case sensitive as it is
> a legay system.
> When we migrate to SQL Server 2000, we will use reporting
> tools via ODBC connection to the database. We would like
> to know can the new system be case insensitive during
> query, especially during the wildcard search.
> Thanks