Re: Text/String Manipulation ISQL

Posted in 1994

Dennis Pimple — 14 Jun 94 04:32:28 GMT — source: Informix-list mailing list archive (1991-1998)

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