Re: Regarding Prepared Statement

Verify that the field type is varchar and not char.  If it is varchar,
try changing db drivers.  The driver could be appending the empty spaces
because it thinks the field is of type char.
 
James

        -----Original Message-----
        From: Inderjit Singh [mailto:[email protected]] 
        Sent: Wednesday, July 16, 2003 7:49 AM
        To: [email protected]
        Subject: Re: Regarding Prepared Statement
	
	
        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