From: greens@diamondsg.com   
      
   you can't parse a field lke that in a query.. as you guessed, you'll need to   
   scan the table to do this.. it should actually be rather easy..   
      
   --   
   Steven Green - Waldorf Maryland USA   
      
   Diamond Software Group   
   http://www.diamondsg.com/main.htm   
   Paradox Support & Sales   
      
   Diamond Sports Gems   
   http://www.diamondsg.com/gemsmain.htm   
   Sports Memorabilia and Trading Cards   
      
   "JoeSpareBedroom"  wrote in message   
   news:u69Ph.5735$B25.2983@news01.roc.ny...   
   >I suspect this can't be done, but who knows? I've got a field that should   
   >contain only UPC numbers, but the raw data file often contains quite a few   
   >erroneous alpha chars. They're just a visual annoyance for the viewer, but   
   >it would be nice to get rid of them. Is there a way to do this with a   
   >query, or would I need to scan the table with a script that hunts for ascii   
   >values within a certain range? I'm using PdoxDOS 4.x.   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)