Have you had the same results using "like"?

>Hi,
>
>I am not able to locate a record using a parametized view of SQL Server data when the field that the parametized view is based on is a 'char' field, and it contains for example '0000000000001'. The problem seems to be the fact that string contains leading zeros. Why is this so? And what could I do about it?
>
>Thanks in advance.
>
>Regards,
>Mike Mayo