Remove trailing spaces in string fields?

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.)
 
J

jp2msft

Your querie will return a string:

Dim strValue as String = CustomQuery() ' VB syntax

Once you have thatuse:

strValue.Trim()

Hope that helps.
~Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trailing Spaces in Merged Cells 1
How do you remove trailing spaces withour Trim function? 8
Trailing characters in form fields 3
Macro to remove trailing spaces in cells 2
When parsing CSV using OleDbConnection, trailing spaces are trimmed 3
Remove trailing spaces in DBRW 1
Trim trailing spaces for name field in query 4
Remove trailing spaces from multiple columns in Excel 8

Top