Hi John,
this is the way! it works!
Thank you
>Hi Francesco, i'm answering you late because sometimes i cant connect so frecuently to internet.
>if you want to have 'SMITHJOHN' in Oracle you must use the concat function in oracle, it replace the + in VFP
>Example: SELECT CONCAT(last_name, firstname) as col1 FROM mytab WHERE concat(last_name,firstname)='SMITHJOHN';
>------------------------------------------------------
>XXLastnameXXFirstname ('SMITHJOHN')