You may also try regular expressions with SQL. REGEXP_INSTR returns the
position of the first occurrence. If the returned position is higher than
*zeros any character a-z/A-Z is included.
Exec SQL Set :isFound = Case When RegexP_Instr(:YourText, '[a-zA-Z]') > 0
Then '1' Else '0' End;
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Koester,
Michael
Gesendet: Wednesday, 09.12 2015 17:54
An: RPG400-L@xxxxxxxxxxxx
Betreff: How to detect a letter?
I'm guessing that someone has already had to do this:
I need to validate that a string contains a letter (A-Z or a-z) as part of
an edit routine for valid email passwords.
I could brute-force this with for-loops scanning for each letter, but I
suspect there is a more elegant solution. Ideas? Preferred solution would
be RPG and/or SQL supported by v7.1.
(Hoped to find a previous discussion of this in the archives, but my
creativity failed me for getting the right search words.) Many thanks.
Michael Koester
Programmer/Analyst
DataEast - Granite State Communications
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list To post a message email: RPG400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/rpg400-l.
midrange.com
