SQLite Forum

Nulls or blanks
Login
Using trim() might be better, depending on what the OP's data means. I had the impression that the difficulty was more fundamental.  And because there are few ways of acquiring data that result in space sequences, I thought to not complicate things any more for the OP.