Re: Text/String Manipulation ISQL

Alastair, In <1994Jun8.091954.13635@duquesne.ie>, you wrote: > > 1: Text/String manipulation with Informix SE and ISQL > > I am using SE 5.00.4 and ISQL 4.10 on an Intergraph 2020 (Unix) and > need to do some text manipulations. I'm trying to match address data from 2 > different tables, ... > Ashington Avenue > ASHINGTON AVE No luck! SQL can't, neither can 4GL. The closest you can come is to use the upshift or downshift functions in 4GL, creating TEMP tables (or converting the data permanently) and comparing the converted data. But the differences in the spelling of Avenue, etc. will mess you up. A recent thread in this newsgroup dealt with Informix's inability to compare strings capitalized differently. Any change to this is somewhere over the horizon. I must recomend unloading the 00's of 000's of recs, passing them though "tr" or like minded filter, making the data all one case. The problem of abbreviations will still need to be addressed. Perhaps the last word in the string could be moved to a different field? > 2: Could anyone recommend any good third party books/documents on Informix > that would provide examples of the kinds of applications that can be achieved > with SQL/4GL Informix's "INFORMIX-4GL by Example" (part # 000-7022) and their "Guide to SQL: Tutorial" (part # 000-7028) are both very good. -- Colin McGrath Internet: colin@scdipc0.ueci.com Raytheon Engineers & Constructors Inc. UUCP: ..!uunet!trac2000!trac3000!cmm 30 S. 17th St Voice: 215-422-3449 Philadelphia, PA, 19101 FAX: 215-422-4095 <Standard disclaimers apply>