Sign in to Community
Sign in to view all badges
We have a field which is am Integer 8 (Small Int). It is present as an enumeration.
How to compare its values in a CRM Connector
eg @FIELD == 0 gives error as we cannot compare small Int with integer
@FIELD == '0' gives error as we cannot compare small Int with String
ToString() and Tointeger() functions also fail and does not work on small Int.
You can compare it like this.
ToString(@FIELD) == ToString(0)
Let me know if this works.