Jump to content

How to compare empty values


newcoder1010

Recommended Posts

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

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...