- Mark as New
- Follow
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report
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