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
>
>