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?
it might depends from your database.
is the upper a valid keyword for your sql database ?
it will happen sometimes
reconnect the database and re enter the credentails of your database and reload it will work
COEP is a SAP table.
SAP SQL is fussy in spaces at where statement.
where FIELD = 'COIN';
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 "
Retrieving data ...