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.
midrange.com
