TableAdapter for DataTable Upper function

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

Answer 1

User-1837497549 posted

Can you send your code ? 

Answer 2

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

Answer 3

User1716267170 posted

Hi jessemandi1,

Have you tried this one?

UPPER(...) LIKE '?'

Thanks.