Re: Text/String Manipulation ISQL

dennis, is it fixed in the new versions? this has been a known bug for quite some time. starting to look like the 'O'ther rdbms vendor... } } Ting Barrow <tingb@delphi.com> writes: } } >4GL will do this neatly. It's easy to UPSHIFT everything prior to } >comparing. } } Beware of a bug in early 4.01 versions that UPSHIFTS underscores into } question marks (or maybe is was vice versa). I had to write a } workaround on some code last year: } } FOR s = 1 LENGTH(string) } IF string[s] MATCHES "[abcdefghijklmnopqrstuvwxyz]" THEN } LET string[s] = UPSHIFT(string[s]) } END IF } END FOR } } yeah, bug workarounds are often a pain. } } ============================================================ } Dennis J. Pimple Informix Software Inc } Senior Consultant Denver Colorado USA } dennisp@informix.com Voice:303-850-0210 Fax:303-779-4025 } -- 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 | +----------------------------------------------------------------------------+