Hi list, I'm in troubleshoting dealing with InStr function as follows
1) Select * from Table1, Table22 where InStr(1, Table2.names, Table1.name)>1 into Selection or 2) Select * from Table1 where InStr(1, any(select Table2.names from Table2), Table1.name)>1 into Selection (Table1 is mappable and Table2 doesn't) Both expressions cause errors. Why?. anyone can help me? Thaks very much in advance. Sergi Gàmiz Ribelles (627481954) REGS DE CATALUNYA S.A. (www.regsa.es) Unitat de Promoció de Regadius i Concentració Parcel·lària c/General Brito, 6, 5è 25007 Lleida tel. 973222838 fax 973222627 [EMAIL PROTECTED] _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
