locked
TableAdapter for DataTable Upper function RRS feed

  • Question

  • User-1146965134 posted

    I am connecting through an ODBC data source to an Oracle database and I would like to use the upper function in my where clause (i.e. UPPER(field) LIKE ?) and it won't allow me to do this.


    Is there something special that I need to do?


    I have VS 2005.


    Thanks in advance for your help.


    --Jesse

    Thursday, October 15, 2009 3:05 PM

Answers

  • User1716267170 posted

    Hi jessemandi1,

    Have you tried this one?

    UPPER(...) LIKE '?'

    Thanks. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 20, 2009 4:20 AM

All replies

  • User-1837497549 posted

    Can you send your code ? 

    Thursday, October 15, 2009 3:16 PM
  • User-1146965134 posted

    SELECT * FROM TABLE WHERE EFF_END_DT='31-DEC-99' AND (LEVEL1 = 1 OR LEVEL1 = 2 OR LEVEL1 = 5 OR LEVEL1 = 6) AND TESS_STAT='A' AND UPPER(EMPLOYEE) LIKE ? ORDER BY LAST_NAME, FIRST_NAME


    Thursday, October 15, 2009 3:24 PM
  • User1716267170 posted

    Hi jessemandi1,

    Have you tried this one?

    UPPER(...) LIKE '?'

    Thanks. 

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 20, 2009 4:20 AM