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,394 of 9,834   
   JoeSpareBedroom to Steven Green   
   Re: Query to find just alpha chars?   
   30 Mar 07 16:01:26   
   
   From: dishborealis@yahoo.com   
      
   "Steven Green"  wrote in message   
   news:460d30ea$1@pnews.thedbcommunity.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   
      
      
   Exactly. And, it's never one of a series of flavors, which might make it   
   easy to say "OK - it's pop tarts, and obviously strawberry", so we can   
   manually fix it. It's always one of a short series from some manufacturer of   
   mouse traps or some such thing, impossible to cross reference in another   
   wholesaler's data, because so few of them carry it.   
      
   --- 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