How to compare empty values

[newcoder1010]

Hi,

 

I am reading a value from excel and then reading another value from database. After that, I am comparing.

 

Excel returns: value - Empty and data type User - Defined.

Database returns a vaue - NULL and data type User - Defined.

 

After that, I compared both as

IF EXCEL = DB THEN  MSGBOX "EQUAL"ELSE MSGBOX "NOT EQUAL"END IF

I was expecting EQUAL message to be displayed but I am getting NOT EQUAL message. Can you please help?

 

Thanks,

N

[justsomeguy]

You'll probably need to normalize the values by converting both of them to a common value before comparing them.