Re: Selecting against values outside the ASCII range!!!

Since "col3" is a Char datatype then

 In this case:
select * from table1 when col3 = 1

1 is a number so an implicit conversion is done. Values in "col3" are tried to be converted into a number type. If there in col3 is at least one non-number value, it raises that error.

You can fix it by

select * from table1 when col3 = '1'

Jan Received on Tue Apr 06 2004 - 10:05:29 CDT