By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE a(
[col] [char](3) NULL,
)
INSERT INTO dbo.a (col)
VALUES (' '),(' '),( ' '),('a'),('ab'), ('abc');
6 rows affected
SELECT col
FROM dbo.a
WHERE Col LIKE '%[ ]%'
| col |
|---|
| a |
| ab |
DROP TABLE dbo.a;