Sign in to follow this  
Followers 0
newcoder1010

How to compare empty values

2 posts in this topic

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
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
Sign in to follow this  
Followers 0