Thanks, so far so good, it was a great help to us. We have used the "SP_HELPSORT" function which made clear that the sqlserver uses case insensitive set order.

a =sqlconnect("relasqlserver")
? a
? sqlexec(a,"SP_HELPSORT","Temp")

How to creat an index is also pretty clear.

However, concerning our question:
'How to create indexes on a field in a related database?'

In VFP we use two tables: rela and contracts. We mean by "a related database" a relation set from one table into the other. Example code:

USE Contracts in 0
USE Rela in 0
SELECT Rela
SET ORDER TO R_relcode
SELECT Contracts
SET RELATION TO C_relcode into RELA
INDEX ON rela.relname INTO C_RELNAME

Translated in words:
We like to order to rela.relname with corresponding Contracts.

In return we like this code transformed into SQL.

We are very pleased with any help.

Jan & David