home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 8,390 of 9,834   
   JoeSpareBedroom to All   
   Query to find just alpha chars?   
   30 Mar 07 14:26:34   
   
   From: dishborealis@yahoo.com   
      
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca