From: agl@wht.KILLSPAM.com.au   
      
   janik@pobox.sk (Jan) wrote in   
   news:81511301.0404060705.7d0d06fe@posting.google.com:   
      
   > 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   
   >   
   Jan,   
       	I've tried that as well, it doesn't work. Doing '1' would indicates   
   that the thing inside the quotes is No 49, the 49th entry, in the ASCII   
   table whilst I have No 1, 3, 9, 11 etc in the ASCII table, values that   
   can't be represented on the keyboard ie I can't represent them between the   
   quotes. On another forum where I asked this question, someone suggested   
   that I wrap the values in chr() and ascii(), depending which way I am   
   going. I've done thins and things are now fine.   
      
       	Thanks for taking the time to reply,   
      
       	Andrew Lowe   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)