Thanks,

Forget it is about SQL Server, not VFP.

Einar, disregard my reply

>There's no INDEXSEEK() function in MS SQL Server.
>
>
>>One of the siolutions in case you have index on userid in the User table:
>>

>>SELECT ;
>>    itemid, ;
>>    IIF(INDEXSEEK(Item.creatorid,.t.,"USER","userid"),USER.username,SPACE(LEN(USER.username))) creatorname, ;
>>    IIF(INDEXSEEK(Item.assigneeid,.t.,"USER","userid"),USER.username,SPACE(LEN(USER.username)))  accname ;
>>  FROM Item
>>
>>