[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
SQR command to distinguish alpha characters from aplha-numer
- Subject: SQR command to distinguish alpha characters from aplha-numer
- From: Zubin Shroff <zshroff@DTTUS.COM>
- Date: Mon, 12 Jul 1999 17:49:32 -0500
- Alternate-Recipient: Allowed
- Conversion: Allowed
- Disclose-Recipients: Prohibited
- Original-Encoded-Information-Types: IA5-Text
- Priority: normal
- X400-Content-Type: P2-1988 ( 22 )
- X400-Mts-Identifier: [/c=US/admd=TeleMail/prmd=Deloitte/; 06752378A70FC3C7-MTAUSCNT1DT]
- X400-Originator: zshroff@deloitte.com
- X400-Received: by ans2-pub.dttus.com (Internal Mail Agent-2); Mon, 12 Jul 1999 17:51:32 -0500
- X400-Received: by ans2-pub.dttus.com (Internal Mail Agent-1); Mon, 12 Jul 1999 17:51:32 -0500
- X400-Recipients: non-disclosure;
Is there an SQR command that can be used to interrogate a field and
determine whether all characters are alphabets or alpha-numeric?
e.g. Given 2 field values of 'JOB' and 'JOB9', we need to determine
that JOB is alpha-only and JOB9 is alpha-numeric.
Just wondering if there is an easier way than to read each character
and look for the first non-alpha character