Re: Text/String Manipulation ISQL

Ting, try the following program: # program to upshift and downshift 4gl functions database stores main define u,c,d char(1) let c = "_" let u = upshift(c) let d = downshift(c) display "Character : ",c display "Upshift : ",u display "Downshift : ",d end main on a sun 690 running INFORMIX-4GL Version 4.11.UC1: Character : _ Upshift : ? Downshift : _ > > 4GL will do this neatly. It's easy to UPSHIFT everything prior to > comparing. If you want to go the other way you can write modules to > DOWNSHIFT everything but the first letter (and then use some table lookups > to fix our wierd English stuff). > > There's also a neat tool to do this - Datalift > -- regards, +----------------------------------------------------------------------------+ | . . | Bob Baskett | | ... ... | Software Engineer | | ..... ..... | Business Systems Integration Group | | .. ... .. | Semiconductor Products Sector | | . . . | Mesa, AZ | | | President, Informix Users Group Of Arizona | | Motorola, Inc. | | +----------------------------------------------------------------------------+ | Sun 690MP 4.1.3, Online 5.01, 4.10.UD1 Tools, Fourgen v4.10.UC1 | +----------------------------------------------------------------------------+