>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).

Answering my own question:

This is because it is nchar(10) there are spaces right padded that I need to take into account. Duh! :)