How to replace(remove) some chars in column

[Art]

Hi! In one table I've got one column with client address, and for parsing purpose it has this char(:) like(st.:Some street,:apt.:30).

Of Course! I don't want to show this char in report.

So, the question is, how can I remove or replace this char from address column?
Thank You in advance!

[Glenn]

Well without knowing how the report is build (passed in data, NeedDataSource, etc).  I would think you can use the String.Replace, if from your sql then use the REPLACE sql funtion.

HTH,
Glenn

[Stef]

Hello,

You can use a Text function as well.

Regards,
Stef
Telerik