×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
What about
SELECT ...
FROM nnnnn
WHERE FLD <> UPPER(FLD)
Eric DeLong
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bruce Guetzkow
Sent: Friday, December 19, 2008 11:30 AM
To: 'RPG400-L Posting'
Subject: SQL equivalent of RPG %Check BIF
All:
I've checked the archives, but can't find anything like this. I suspect
this has been asked before, but I haven't found the right search
criteria.
Is there a function in SQL that is equivalent to the %check BIF in RPG?
I'm trying to scan a file, looking at the name field to find any names
that contain any characters other than upper-case alpha or blanks. It's
pretty simple in RPG, but I'd like to be able to do this in SQL if
possible.
Thanks in advance,
--Bruce Guetzkow
--
This is the RPG programming on the IBM i / System i (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
