I assume taht you still get the same error? What is the type of the loan_mortgagor_info.loan_id field and value of sqlkey variable?

>sqlselect = "Select lender_offices.lend_offc_name, " + ;
>            "lender_offices.lend_offc_identifier, "+;
>            "loan_mortgagor_info.loan_id "+;
>            "From loan_mortgagor_info, lender_offices " + ;
>            "Where loan_mortgagor_info.loan_id = "+sqlkey + ;
>        " and lender_offices.lend_id = loan_mortgagor_info.orig_lend_id " + ;
>   "and lender_offices.lend_offc_id = loan_mortgagor_info.orig_lend_offc_id" 		
>= sqlexec(fics,'&sqlselect','lender_office')

>I think I just messed up with the copy & past of the code.
>
>Here is my code again