Try to trim the NAME before comparisons.
 
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

Reply via email to