RE: orders from web - names

D Lo              C                   'abcdefghijklmnopqrstuvwxyz'
D Up              C                   'ABCDEFGHIJKLMNOPQRSTUVWXYZ'

C                   Eval      Last_name_Upper = %XLATE(Lo:Up:Last_Name) 


Francis 



-----Original Message-----
From: rpg400-l-bounces+flapeyre=stei.com@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+flapeyre=stei.com@xxxxxxxxxxxx] On Behalf Of
steema@xxxxxxxxxxxxx
Sent: Wednesday, March 29, 2006 10:10 AM
To: RPG programming on the AS400 / iSeries
Subject: orders from web - names

HI We get some orders from web but through a service. Sometimes the customer
had entered bad data. For example the name will be replicated in the first
address field but will be in lower case, and the name may be spelled out
rather than a nickname (Patrica vs. Pat), but it seems the last name is
always there, altho in lower vs. upper.

How can I convert lower to upper so as to compare this last name, via the
SCAN ?

Thanks,
Steve
--
This is the RPG programming on the AS400 / 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.