By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE a(
[col] [varchar](3) NULL,
)
insert into a values (' '),(' '),( ' ')
3 rows affected
/*Works*/
select *
from a
where ' ' LIKE col AND col = ' '
| col |
|---|
/*Does not work*/
select *
from a
where col = ' '
| col |
|---|
/*Does not work*/
select *
from a
where col like ' '
| col |
|---|