Want to compare string

[Anonymous]

Hi,

I want to compare a string where if some field " ABC=' 25' " its not working where as if i put the same condition in opposite way i;e " ABC<> '25' thats work!! I am unable to understand. Could anyone tell me the reason or solution for it ?

Thanking you in advance

Best,

Shubham Kumar

[jagan]

Hi,

How many values are there in the field, if there is only one value it works as expected, if there are multiple values then ABC='25' returns false, because while comparing a field with a given value(25), the field has multiple values so it returns false.

Regards,

Jagan.