Regarding Prepared Statement

[K R Viju]

List,   We have a table called CUST. CUST has one column called NAME Varchar (25) When i insert a row using PREPARED STATEMENT, thou i insert a string of length 10, it adds space and inserts 25 length.   what cud be the problm? am using MS SQL 2000.   Thanks Viju