>>>You declared
>>>

>>>'cus_LastName  nchar(5)'
>>>

>>>That ways you ALWAYS will have 5 chars. Declare it as nvarchar() instead.
>>>
>>
>>Actually cus_Number is declared as nchar(5), not cus_LastName.
>>
>>If it is declared as nchar(5) in the database and the business rules are that it will always have 5 characters, should I still use nvarchar in the SP?
>
>
>Check your first post:
>

>
>SELECT @paramlist = '@cus_Number   varchar(50),  ------ ?????????????
>                     @cus_LastName  nchar(5)' ------ ?????????????
>

>
>
>Yes, if you want to use LIKE '%somechars%' syntax.

Thanks. I don't have that old code around anymore and my new code has it the correct way, but I'll change it as you suggest.