Does ProvideX PVX+ support a case expression using the ODBC driver? I am currently writing it like the following:
SELECT
CASE WHEN IC_UM_BY_ITEM.OK_SELLING = 'Y' THEN 1 ELSE 0 END AS isdefault
FROM IC_UM_BY_ITEM
We use cookies to ensure the best experience on our website. This includes analytics, personalization, and marketing purposes. Some cookies are essential for the website to function properly.
By clicking "Accept", you consent to our use of cookies. You can read more about how we use cookies and how you can change your preferences in our Privacy Policy.