Hitesh Shah
4th March 2022, 12:03
Hi All,
I have a set field in the table and I want to use it in SQL query . I understand bit operations (bit.in ,bit.or etc) can help to evaluate these in programs . However i want to use it in SQL query (query.extend.where) to filter records based on certain conditions .
Can we do this in SQL query . What are the best way to do this without changing table /field structure and in case where DAL is present on the table.
I have a set field in the table and I want to use it in SQL query . I understand bit operations (bit.in ,bit.or etc) can help to evaluate these in programs . However i want to use it in SQL query (query.extend.where) to filter records based on certain conditions .
Can we do this in SQL query . What are the best way to do this without changing table /field structure and in case where DAL is present on the table.