Decision Optimization

Decision Optimization

Delivers prescriptive analytics capabilities and decision intelligence to improve decision-making.


#Analytics
#DecisionOptimization
#DecisionOptimization
 View Only
Back to discussions
Expand all | Collapse all

How to solve issue with upper case/lower case

  • 1.  How to solve issue with upper case/lower case

    Posted 07/15/09 08:19 PM

    Originally posted by: SystemAdmin


    [Boon said:]

    Hello,

    I have OPL model that reads the data from MS Access. Now, when the data in Acess spelled "Monday", and the code in my OPL spelled "monday", they don't match.

    I would like to know if there is a command that convert the text to all capitals or to all lower case?

    Thank you,
    Boon
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


  • 2.  Re: How to solve issue with upper case/lower case

    Posted 08/04/09 11:52 PM

    Originally posted by: SystemAdmin


    [UDOPS said:]

    If you are using ODBC, maybe use sql queries that massage the data as it is retrieved?
    #DecisionOptimization
    #OPLusingCPLEXOptimizer


Related Content