Can I easily trim the whitespace for a databound HyperLinkColumn?

[Sean Aitken]

Does anyone know the easiest way to trim the whitespace from a CHAR(...)
bound value coming from a database and used with a HyperLinkColumn?

In this case, the column is setup using:
....
<asp:HyperLinkColumn Text="Edit Taxes" DataNavigateUrlField="AccountID"
DataNavigateUrlFormatString="TaxDetail.aspx?id={0} &amp;src=accts"></asp:HyperLinkColumn>
....

The problem is that the output looks like:
".../TaxDetail.aspx?id=00044%20%20%20%20%20%20%20%20%20 %20%20&src=accts"

So, I want to trim the data from the DB before it binds to the column
for all rows.

I have looked at the format string options, but I can't see any way to
do it with the format string.

Any ideas?

Cheers!
-Sean

[Elton W]

Select RTRIM(AccountID) As AccountID, ... From ...

HTH

Elton Wang
el********@hotmail.com
"Sean Aitken" wrote:

Does anyone know the easiest way to trim the whitespace from a CHAR(...)
bound value coming from a database and used with a HyperLinkColumn?

In this case, the column is setup using:
....
<asp:HyperLinkColumn Text="Edit Taxes" DataNavigateUrlField="AccountID"
DataNavigateUrlFormatString="TaxDetail.aspx?id={0} &src=accts"></asp:HyperLinkColumn>
....

The problem is that the output looks like:
".../TaxDetail.aspx?id=00044%20%20%20%20%20%20%20%20%20 %20%20&src=accts"

So, I want to trim the data from the DB before it binds to the column
for all rows.

I have looked at the format string options, but I can't see any way to
do it with the format string.

Any ideas?

Cheers!
-Sean