Remove trailing spaces in string fields?

  • Thread starter Thread starter Philippe Requilé
  • Start date Start date
P

Philippe Requilé

I use the ado.net IdxConnection to connect to an informix database.
Unfortunately every field of type String in the dataset has trailing
blanks.
How can I get rid of them?

(In DbExpress (Borland Delphi) I could put "trim char" in the
connectionstring.)
 
Your querie will return a string:

Dim strValue as String = CustomQuery() ' VB syntax

Once you have thatuse:

strValue.Trim()

Hope that helps.
~Joe
 
Back
Top