Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!caen!spool.mu.edu!uunet!zephyr.ens.tek.com!uw-beaver!mit-eddie!news.media.mit.edu!news.media.mit.edu!dnb From: dnb@meshugge.media.mit.edu (David N. Blank) Newsgroups: comp.databases Subject: Tricky Paradox query Message-ID: Date: 7 Jun 91 16:28:39 GMT Article-I.D.: meshugge.DNB.91Jun7112839 Sender: news@news.media.mit.edu (USENET News System) Distribution: comp Organization: M.I.T. Media Laboratory Lines: 18 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\ / |\ / \