How to trim value in ssrs report

In the result , i have  the data as follows,

:ddf :rrrrr:dfdf

I have to remove the first character ":" only from the data

the result should be as follows,
 ddf :rrrrr:dfdf


How should do it?!
For ex  LTrim(!Fields.sss.Value),":"
ManikannanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
ManikannanConnect With a Mentor Author Commented:

I have used the following and got the result.

=Mid(First(Fields!C_ADDRESS_INFO.Value),2,250)
0
 
ManikannanAuthor Commented:
I got the result by using this query
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.