[comp.databases] Tricky Paradox query

dnb@meshugge.media.mit.edu (David N. Blank) (06/07/91)

Howdy-
  Here's a place I am dying to use a regular expression, but since
Paradox queries don't have them I have to look for a trickier way.
Here's my question: given a field which is alphanumeric, how do I
query out only the records that have any alpha characters ([a-zA-Z])
in this field?  For instance, if the field contained:
          1111111
          2222222
          D111111
          ABCDEFG,
I want to retrieve the records D111111 and ABCDEFG.  Thanks.
       Peace,
          dNb
--

 David N. Blank                      o/    \  /    \ /     /      \o   
 M.I.T. Media Laboratory            /#      ##o     #     o##      #\
 E15-473F, (617) 253-2169           / \    /  \    /o\    / |\    / \