In both tables the field 'pers_no' in NUMERIC(11).

The following works:

lcSql = "SELECT RTRIM(PERS.last_name) || ', ' || RTRIM(PERS.first_name) AS Employee, " + ;
" EMP.pers_no, " + ;
" EMP.login_lvl " + ;
"FROM EMP, " + ;
" PERS " + ;
"WHERE EMP.pers_no = PERS.pers_no (+)" + ;
" AND EMP.pers_no = " + TRANS(lnEmpPersNo) + " " + ;
"ORDER BY PERS.last_name, " + ;
" PERS.first_name"

lnHandle = sqlexec(lnSatHandle, lcSql, 'test_cursor')

I'll kepp looking into it. I thank you for your patience. I'm taking shots in the dark here.

Mike