Hey Guys,
I have a strange behaviour (at least for me).
I have 3 values in one of my columns.
- 1550_1010
- 1610_1010
- 1610test
No results even if I would expect one:
SELECT * FROM chart WHERE accno = ‘1550_1010’;
SELECT * FROM chart WHERE accno IN (‘1550_1010’);
Suddenly a result but I just added another IN term…
SELECT * FROM chart WHERE accno IN (‘1550_1010’, ‘’);
Gives me a result but only as long as I have the value 1610test in there…
SELECT * FROM chart WHERE accno = ‘1610_1010’;
SELECT * FROM chart WHERE accno IN (‘1610_1010’);
Is this somehow a known “issue” or is this for some reason a logicaly explainable?
Cheers,
JC