Cast varchar to an integer in Teradata -
here have: select * trans transid in ( select cast(trim(firstname) int) customer trim(firstname) between '0' , '9999999999999999' , custid not in (select custid address) ) have numerical values in firstname column have trace trans table, in values in firstname column transid's. getting error: select failed. 2620: format or data contains bad character your fails because it's true '0foo', too. what's teradata release? in td14 use regular expression: where regexp_instr(trim(firstname), '^[0-9]+$') > 0 before need udf, eisinteger or eisbigint of ebay udfs