>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! :)