>But i got 3 questions and hope someone can help me.
>- How to create indexes on a uppercase character fields;

You can't. SQL Server doesn't allow indexes to be created on expressions. You may not have to have the index. What sort order was you server installed with. If it's using a case in-sensitive sort order, you just need to index the column. Use SP_HELPSORT to determine the character set and sort order that were installed.

>- How to create indexes on combined fields;

An index on multiple columns is called a composite index. The statement would look something like:

CREATE INDEX index_name ON table_name(column1, column2, ... columnn)

Also, SQL Server will allow a composite index to contain columns that are of different datatypes. So this index is legal:

CREATE INDEX garbage ON Titles(title, price)

where the title column is char and the price column is money.

>- How to create indexes on a field in a related database

I'm not sure what you're asking. A SQL Server index can only reference columns in one table.

-Mike