Tricky Paradox query 
Author Message
 Tricky Paradox query

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\    / |\    / \



Wed, 24 Nov 1993 00:28:39 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Paradox 4.0 PAL questions - tricky

2. Help: Tricky Data Transformation (Paradox)

3. Tricky query for me, should be simple for you

4. Tricky Query Problem

5. tricky CASE WHEN query...

6. A Tuff Tricky One - Please Help with Queries

7. tricky query (for me atleast)

8. Tricky "most recent sales" query

9. Tricky query question.

10. Tricky update query

11. tricky query

12. Tricky UPDATE / Select SQL query problem.


 
Powered by phpBB® Forum Software