Re: Can we tell informx to ignore or cast field types in a join ??

>>> 'T' is created as 'select .... into temp T' and has an integer field >>> (because the base table has integer field). >>> >>> Now one table 'P' has values with alphabets in a char. field on which 'T' >>> joins and informix gives 1213 error(char. to numeric conversion error). >>> >>> 1) Can we tell informix to compare but ignore if the values are >>> incompatible .? why not just select out the rows in P with incompatible values? they can't be useful in the join anyway. select T.i from T, P where P.c not matches "*[A-Za-z]*" and T.i = P.c joey duhon@netcom.com