How to compare Small Int data type used in Enumeration in Adobe Campaign

[#1]

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.

[#2 · Accepted solution]

We have solved this problem by using 

IfEquals(ToString(@field),'0' ,'ABC' ,'Error');

in CRM Connector.

Where field was an integer 8 bit (Small Int).

== did not work

[#3]

Hello @Alolika 

You can compare it like this.

ToString(@FIELD) == ToString(0)

Let me know if this works.

Thanks