SQL Where

[amit_saini]

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,

AS

[Miguel_Angel_Baeyens]

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]

It should work fine

[Chanty4u]

remove single quotes and try

WHERE OBJNR BETWEEN OR000070000000 AND OR000079999999 ;

[Chanty4u]

or

WHERE (OBJNR BETWEEN OR000070000000 AND OR000079999999);