Value with _ (underscore)

Hey Guys,

I have a strange behaviour (at least for me).

I have 3 values in one of my columns.

  1. 1550_1010
  2. 1610_1010
  3. 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

Works for me: https://rextester.com/FLMD88939

I guess there is something you are not telling us.

Yeah, meanwhile I figured out, deleting the record and reinserting it solves the problem.

Any idea what could possibly have gone wrong on the first insert?