You could try something like this:

select 'select top 5 * from '+s.name+'.'+t.name+' where '+c.name+' NOT LIKE ''__'''
from sys.schemas s
INNER JOIN sys.tables t on s.schema_id=t.schema_id
INNER JOIN sys.columns c on t.object_id=c.object_id
where c.name = 'State'


Or use the LEN() function that would ignore trailing spaces