Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ruma_barman
New Contributor II

Function in where clause doesn't work in sql

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?err.png

4 Replies
agigliotti
Honored Contributor II

Re: Function in where clause doesn't work in sql

it might depends from your database.

is the upper a valid keyword for your sql database ?

sureshqv
Esteemed Contributor III

Re: Function in where clause doesn't work in sql

Hi,

it will happen sometimes

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

martinpohl
Valued Contributor II

Re: Function in where clause doesn't work in sql

COEP is a SAP table.

SAP SQL is fussy in spaces at where statement.

where FIELD = 'COIN';

regards

arvind654
Honored Contributor II

Re: Function in where clause doesn't work in sql

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 "