>>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
