Re: Char to integer in "WHERE" clause

Informix does the conversion automatically. Just try the select like SELECT * FROM table1 WHERE zip_file[1,2] - zip_code[1,2] > 2 should work... > > I need to convert the a character column to integer and perform > some operations in a WHERE clause. > > For eg: > [in foxpro] > SELECT * FROM table1 > WHERE ABS( VAL( LEFT(zip_file,2)) - VAL(LEFT(zip_code,2))) > 2 ;> > In the above example, I'm finding the difference between first > two digits of 2 char columns.