RE: Converting to upper case

[Eric DeLong <Eric.DeLong@xxxxxxxxxxxxxxxxx>]

     Good one John, you stole my idea..... :) Most of the other 
     solutions involved the RPG opcod XLATE, but the problem I see with 
     that approach is codepage support. XLATE won't work properly in all 
     codepages. Does SQL?
     
     Eric DeLong


______________________________ Reply Separator
_________________________________
Subject: Re: Converting to upper case
Author:  "jpcarr@TREDEGAR.COM" <SMTP:jpcarr@TREDEGAR.COM> at EXCHANGE
Date:    12/19/00 6:26 AM


How about this
     
update FILE set FIELD  = upper(FIELD)
     
John Carr
     
-------------------------------
I am looking for an easy way to convert an alpha field to all upper case 
characters.  anyone have any suggestions?
Kevin Blankenship
     
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com. 
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator:
david@midrange.com 
+---
+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---