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