Re: SQL: WHEN FIELDA "ISNOT NUMERIC"...?

[Alan Shore <AlanShore@xxxxxxxx>]

Hi Peter
at the moment I don't have access to the IBM manuals to verify what I am
about to say
I had the same problem a couple of years ago. The way that I went was to
use XLATE (or something like that)
If you translate every alphabetic to blank and translate blank to another
character (for example @) you can see if the result is blank (meaning that
the field contained nothing but alpha characters



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx
"If you're going through Hell, keep going" - Winston Churchill


                                                                       
             Peter Vidal                                               
             <Peter_Vidal@pall                                         
             .com>                                                      To
             Sent by:                  midrange-l@xxxxxxxxxxxx         
             midrange-l-bounce                                          cc
             s@xxxxxxxxxxxx                                            
                                                                   Subject
                                       SQL: WHEN FIELDA "ISNOT         
             08/15/2007 09:46          NUMERIC"...?                    
             AM                                                        
                                                                       
                                                                       
             Please respond to                                         
             Midrange Systems                                          
                 Technical                                             
                Discussion                                             
             <midrange-l@midra                                         
                 nge.com>                                              
                                                                       
                                                                       




Good morning all:

I want to use a simple SQL statement that will retrieve all records on
which the field in question has all characters, no numbers.  For example:

FIELDA = 'ABCDEF    '

If I have FIELDA = 'ABCDEF7   ', I do not want to list it.

I read in the archives that here is no function like %CHECK in SQL or
stuff like that but I was wondering if there is a simple way of doing
this, and probably is.

TIA,


Peter Vidal
MAPICS IT Technical Support Team / SR System Analyst
10540 Ridge Rd., Ste 203, New Port Richey, FL 34654-5111
http://www.pall.com

"He who kneels the most stands best."
D.L. Moody

--------------------------------------------------------------------------------


Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.


--------------------------------------------------------------------------------

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.