Correct syntax for < or > in SQL Statements while creating the Data Models/Data Sets

Hi,

We have observed that when we create a Data Set through Query builder and provide the < or > condition for any parameter with values, the final query takes the following syntax:

"F4211"."SDNXTR" <= '561'
 and  "F4211"."SDLTTR" >= '520'

where as an example F4211 is table name, SDNXTR and SDLTTR are parameters and 561 and 520 are values.

But when we generate the XML, we had seen it generate the same records (like 502, 999) for all rows, which is not correct.

When we had removed the single quotes from the values i.e 561 and 520, it generates completely different values.

So, please let me know what is the correct syntax for < and > conditions in data sets in BI Publisher.