Re: Regarding Prepared Statement

Try to trim the NAME before comparisons.
See http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316626
<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