I have a query like this:

SELECT [PolicyNumber]
	FROM [dbo].[Policies]	
		WHERE ([PolicyNumber] LIKE '%1')

this returns no records.

If I change it to this:

SELECT [PolicyNumber]
	FROM [dbo].[Policies]	
		WHERE ([PolicyNumber] LIKE '%')

then I get two records, one with PolicyNumber = '00001'

Why doesn't my first query pull this record out?

PolicyNumber is defined as nchar(10).