Re: Regarding Prepared Statement

[Inderjit Singh]

Try to trim the NAME before comparisons. See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316626 for more details.   Hope this helps Inderjit   -----Original Message----- From: K R Viju [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2003 2:47 PM To: [EMAIL PROTECTED] Subject: Regarding Prepared Statement 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