https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-question-to-find-mod/m-p/12067582#M1969787 <P>Hello, </P> <P>I need help in building a select statement to pull entries where col1 % col2 = 0. I know i can use MOD operation in select statement in HANA. Just wondering how to get it done in open sql. </P> <P>Thanks,</P> Wed, 21 Aug 2019 16:17:01 GMT former_member198680 2019-08-21T16:17:01Z https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-question-to-find-mod/m-p/12067582#M1969787 <P>Hello, </P> <P>I need help in building a select statement to pull entries where col1 % col2 = 0. I know i can use MOD operation in select statement in HANA. Just wondering how to get it done in open sql. </P> <P>Thanks,</P> Wed, 21 Aug 2019 16:17:01 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-question-to-find-mod/m-p/12067582#M1969787 former_member198680 2019-08-21T16:17:01Z https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-question-to-find-mod/m-p/12067583#M1969788 <P>MOD since 7.40 <A href="https://help.sap.com/doc/abapdocu_740_index_htm/7.40/en-US/index.htm?file=abensql_arith_func.htm" target="test_blank">https://help.sap.com/doc/abapdocu_740_index_htm/7.40/en-US/index.htm?file=abensql_arith_func.htm</A></P> Wed, 21 Aug 2019 19:33:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/open-sql-question-to-find-mod/m-p/12067583#M1969788 Sandra_Rossi 2019-08-21T19:33:43Z