Everyone a great god for help, my data in the table contains a null value, want to change the data display, but when I check the allow blank value will pop up the following tips, that how to screening of null values,

CodePudding user response:

You can try to write SQL try additional filter condition

CodePudding user response:

In case the when is ok, but you have to change the field and watch too much, so want to ask you is there any easier way to do this,

CodePudding user response:

This is to allow the blank value, is not null, you take number into the corresponding fields ISNULL (fields, ' ') try