Re: Uppercase conversion
Is there a way to do something in INFORMIX setup
to make a query case insensitive?
So for a search query,
Select A from tablename where A matches "ABC*"
will return "Abc", "abc", "aBCD" ...
Chengteh
}
} albertob@flash.net wrote:
} >
} > Hi,
} > I am new to Informix. Does anyone knows how to convert a field to
} > Uppercase
}
} the upshift command, as in
}
} let variable = upshift(variable)
}
} > or to make a query condition not case sensitive?
}
} The easiest method if you are creating an app and data is not yet
} present is to use upshift. (or downshift). However, this is not always
} desired or practical. Therefore, you could use a function like the one
} below after inputs and in constructs (though this is more work and
} commits the data to look like the updown format). Also, you can check
} the faq at www.iiug.org, where I believe there is yet another
} not-perfect-but-workable solution.
}
} Tim
}
} Following find an updown function in 4gl that may be useful for your
} purpose or other purposes:
}
} ---------------------------------------------------------------
} #########################################################################
} # #
} # MASTERS SOFTWARE COMPANY #
} # #
} # PROPRIETARY DATA #
} # #
} # This document contains trade secret data which is the property of #
} # Masters Software Company, Timothy M. Hood. Information contained #
} # herein may not be used, copied or disclosed in whole or in part #
} # except for maintenance and development of Practice Master, also known #
} # as Legal Master. Any other use is in violation of the copyright held #
} # and maintained by Masters Software Company, Timothy M. Hood. #
} # #
} # This material is also copyrighted as an unpublished work under #
} # Sections 104 and 408 of Title 17 of the United States Code. #
} # Unauthorized use, copying or other reproduction, including the #
} # removal of this copyright notice is prohibited by law. #
} # #
} # Anyone posessing this document agrees to spontaneous inspection by #
} # the copyright owner(s) at any future date and time during the life of #
} # the copyright to verify this copyright notice is intact. #
} # #
} #########################################################################
}
} #########################################################################
} # #
} # MODULE: updown.4gl #
} # #
} # DESCRIPTION: #
} # #
} # This module contains the updown function. #
} # #
} # FUNCTIONS: #
} # #
} # Function Name Description Location #
} # ===================== ================================== ======== #
} # updown Upshifts and Downshifts a string internal #
} # to make it a correctly capitalized #
} # proper name. #
} # #
} # GLOBAL VARIABLES: #
} # #
} # n/a #
} # #
} # MODULE VARIABLES: #
} # #
} # n/a #
} # #
} # SCCS INFORMATION #
} # ~~~~~~~~~~~~~~~~ #
} # #
} # Module Name ..... %M% #
} # Version ......... %I% #
} # Last Update ..... %G% #
} # #
} #########################################################################
}
} #########################################################################
} # #
} # FUNCTION: updown #
} # #
} # DESCRIPTION: #
} # #
} # This function formats a string to look like a correctly capitalized #
} # proper noun. For example, "TIMOTHY M. HOOD" becomes "Timothy M. Hood" #
} # and "dR. joHN mcdOUGal" becomes "Dr. John McDougal". #
} # #
} # ARGUMENTS RECEIVED: #
} # #
} # str The string to be processed #
} # #
} # ARGUMENTS RETURNED: #
} # #
} # str The string that was processed #
} # #
} # LOCAL VARIABLES: #
} # #
} # see below #
} # #
} # TABLES: #
} # #
} # Name Access #
} # ================= =======================