tags:

views:

51

answers:

0
Q: 

Crystal Reports compare does not work without trim

{AR_Customer.CustomerType} is a 4 character field

{AR_Customer.CustomerType}<>"S" does not return all records where this is true unless I do it this way: trim({AR_Customer.CustomerType})<>"S"

in the actual database the NULL fields are the ones I'm missing.

So this tells me than NULL is the same as "S" -- I don't think so, but that's how Crystal is reacting without trim()

Is there a general rule here that I need to understand?

related questions

Pagination Problem [PHP]
Algorithm to determine the "usual" cash payment amounts for a given price
Best way to learn First Order Logic
ASP.NET logic / connection pooling and error handing
Boolean Expression
Boolean logic rule evaluator
Why C++ cannot be parsed with a LR(1) parser?
How do I convert a number to two's complement in verilog?
Correct order for control structure logic (true/false, false/true)?
What problems are best solved with Logic Programming?
Struts Logic Problem
Struts logic tag problem
Looking for simple rules-engine library in .NET
Select Poorly Used Start and End Dates From Facility Table
State and time transending logic and program flow?
Awk scripting help - Logic Issue
Why does "abcd".StartsWith("") return true?
Should LOGIC-techniques be blended into Mainstream Programming?
How to logically organize recurring tasks?
What would be the best algorithm to find an ID that is not used from a table that has the capacity to hold a million rows.
Testing ladder logic
Efficient synthesis of a 4-to-1 function in Verilog
Teaching someone to program
Most succinct way to determine if a variable equals a value from a 'list' of values
C# logic order and compiler behavior