• Good question. If you had wanted to be really sneaky...

    DECLARE @Example TABLE (col1 VARCHAR(10))

    INSERT @Example VALUES ('X'), ('X' + SPACE(1)), ('X' + SPACE(2))

    SELECT COUNT_BIG(*) FROM @Example AS e WHERE col1 LIKE 'X' + SPACE(1)

    SELECT COUNT_BIG(*) FROM @Example AS e WHERE col1 LIKE N'X' + SPACE(1)