Re: How to select upper case fields??? Pleaes help!!! Thx.

Posted in 1997

MarkDenham@aol.com — 15 Jun 1997 01:03:19 -0400 — source: Informix-list mailing list archive (1991-1998)

Mike You have several options: 1) Use a stored procedure to create an upshift function for use in SQL. There is one available in the informix faq http://www.iiug.org. 2) Add another field to the table that contains the data upshifted. Allow the user to using this field instead of the original, but display the contents of the original field. 3) If you have version 4.12 or later of 4GL, use the AFTER CONSTRUCT statement to change the seach pattern from, say FrEd to [Ff][Rr][Ee][Dd]. I am sure there are several more. Mark MarkDenham@aol.com (home) Denham.M@amstr.com (work)