in order to use the wildcard % you need to use th LIKE statement.
select * from table where column like '%';