>I want to do a remote view and link tables on Vendor_number, however Vendopr_number in one table is Character 9 and it is an INT in other table.
>
>How do you join tables on different data types?
>
>table a Fields invoice_num, char 20 Vendor_number Char 9
>
>Table b Fileds Vendor_number INT vendor_name Chr 35
>
>I am trying to do a view that shows a.Invoice_num and b.Vendor_name

** No optimize for this
SELECT ... FROM TableA;
        .... JOIN TableB ON ALLTRIM(TableA.Vendor_number) = ALLTRIM(STR(TableB.Vendor_number))...

*** Depens of Indexes
SELECT ... FROM TableA;
        .... JOIN TableB ON PADR(ALLTRIM(TableA.Vendor_number),9) = PADR(ALLTRIM(STR(TableB.Vendor_number)),9) ...