I'm in the same situation .
-13 --- characters length should be 3 but i get 13 space characters so i cast(substr( MaxTemp,1,3) as char(3)). now i need to convvert the char(3) to integer
cast(cast(substr( MaxTemp,1,3) as char(3)) as integer) but i get an errror
Failed 2621 bad character in format or data of table