SELECT *
FROM USERS
WHERE USERS.USERNAME Like '%D%';

This query simply shows no results, While

SELECT *
FROM USERS
WHERE USERNAME NOT Like '%D%';

Shows the whole table.

I have a table called USERS, and a column called USERNAME, and a user called Danny. Why doesn't it work?

Thanks!