Function in where clause doesn't work in sql

[ruma_barman]

When we are trying to use upper function while retreiving data from database using the query  like Select * from Table_A where upper(Field)='COIN' shows error.What can be the reason?

[agigliotti]

it might depends from your database.

is the upper a valid keyword for your sql database ?

[Chanty4u]

Hi,

it will happen sometimes

reconnect the database and re enter the credentails of your database and reload it will work

[martinpohl]

COEP is a SAP table.

SAP SQL is fussy in spaces at where statement.

where FIELD = 'COIN';

regards

[MK9885]

Maybe try below query, not sure if that would work?

Select * from Table_A where 'upper(Field)'=COIN"

You might need it to escape with the back ticks like "