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,393 of 9,834   
   Steven Green to All   
   Re: Query to find just alpha chars?   
   30 Mar 07 11:46:42   
   
   From: greens@diamondsg.com   
      
   > I don't need to fix them, Steve. I just need to eliminate them.   
      
   then the query IS the answer (no pun intended)   
      
   delete | ..a.. or ..b.. or ..c.. | (etc)   
      
   problem is, you'll have to do more than one query, or more than one line in   
   the query, because that'll be way too many characters to insert into the   
   query form.. the limit is either 128 or 255.. I forget which, but I think   
   it's 128..   
      
   on the other hand, the point of UPC codes, and things like that, is to   
   eliminate stupid "typo" errors.. but it seems that the source data here is   
   total crap..   
      
      
   --   
   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   
      
   --- 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