Avatar

Correct answer by
Community Advisor

Hi @Greeshma_Sampath1 ,

It is due to SQL not ACC. The comparison operator will return different result based on the data type of operand used in your case. That's why, when you pass '3' you are getting a different result than 3.

 

If you want a proper numeric comparison, then the field shall be numeric one or you can write some expression to cast the values if you are sure about the possible values.

 

Cheers,

Deb

View solution in original post