Solved IsNull not working in query (4 Viewers)

[June7]

I edited my previous post while you were reading. Review again.
Did you run UPDATE?

I thought it would be an empty string because length is 0. However, changing to No did not convert to Null. Maybe it allowed empty string to stay. Whatever it is, run UPDATE to eliminate.

How did this data get into table? Can you expect to face this issue again?

 

[hrdpgajjar]

I edited my previous post while you were reading. Review again.
Did you run UPDATE?

I thought it would be an empty string because length is 0. However, changing to No did not convert to Null. Maybe it allowed empty string to stay. Whatever it is, run UPDATE to eliminate.

How did this data get into table? Can you expect to face this issue again?

Many thanks, everything works perfectly now. Learn a lot from this. Never imagined that "ZLS" could affect this much. anyways, thanks for the big assist Cheers!!!