>>Did you try the LIKE clause instead of =? Unlike VFP, Oracle will not compare strings of differing lengths without the LIKE clause.
>
>Sorry Larry, I copied the last "version" of the prg, but I tried both (one of them with a Trim() ):
>

> SQLexec (nJDEHandle, "select * from user_indexes where upper(table_name) = 'F4211'", "CurOracle")
> SQLexec (nJDEHandle, "select * from user_indexes where trim (upper(table_name)) = 'F4211'", "CurOracle")
> SQLexec (nJDEHandle, "select * from user_indexes where upper(table_name) like 'F4211%'", "CurOracle")
>

>
>They all give the same empty cursor as result.
>

Fernando,
Who is the owner of the table in question? User_Indexes only has entries for tables that are owned by the current user. Try using All_Indexes. This is a view that has entries for all indexes that the current user has access to, not just the ones he owns.

HTH.