topic Re: SQL Where in QlikView

SQL Where

amit_saini — Thu, 03 May 2018 13:19:12 GMT

Hi Folks,

Can you please help if where condition bold is correct or not?

SQL Select GJAHR OBJNR MEINH KSTAR WRTTP GKOAR PERIO VRGNG WKGBTR MEGBTR BEKNZ from COEP

WHERE OBJNR BETWEEN 'OR000070000000' AND 'OR000079999999';

I just want to load OBJNR numbers of this range OR000070000000 to OR000079999999

Regards,

Miguel_Angel_Baeyens — Thu, 03 May 2018 13:31:13 GMT

If the SAP Connector (or any other driver you are using) accepts it and the underlying DBMS also, it will work.

Syntax could be different for each DBMS, you should look into its own documentation.

If you are looking a way of doing it on the LOAD side (QlikView) instead of the SELECT side (driver), then you could do:

LOAD *

WHERE

OBJNR >= XX

AND OBJNR <= YY

;

SQL SELECT

...

;

However, bear in mind that if values are not numeric, they will be sorted ASCII first (AA00 is higher than aa22)

sasiparupudi1 — Thu, 03 May 2018 13:44:59 GMT

It should work fine

Chanty4u — Thu, 03 May 2018 15:35:10 GMT

remove single quotes and try

WHERE OBJNR BETWEEN OR000070000000 AND OR000079999999 ;

Chanty4u — Thu, 03 May 2018 15:36:20 GMT

WHERE (OBJNR BETWEEN OR000070000000 AND OR000079999999);