Now in the where condition in a SQL to determine whether the field 1 & lt;> Field 2

But the field 1 and 2 are there may be a null value, can you tell me how to deal with?

CodePudding user response:

ISNULL (field 1, ' ') & lt;> ISNULL (field, 2 ')

CodePudding user response:

Methods can be upstairs

CodePudding user response:

LZ must advise if it is null, the judgment of what are the rules in detail.
For example, the range is null return is true or false.