Retrieve data without trailing space with ADO recordset?
I have a VB6 application using ADO with MS SQL7 database. When I get
data with ADO recordset, the data for each column always has some
trailing spaces if the data value does not take the full length of the
column size. I have to add TRIM() for all of them. If I miss one, I
will get incorrect data value.
Is there any way to retrieve data without trailing spaces?
Thank you very much in advance.
Janet
Sent via Deja.com http://www.*-*-*.com/
Before you buy.