>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?