How to trim the first 2 characters of a field?

Question

I'd like to create an expression that if the stagename is < 5 then print the comments, else nothing)

1) Field!MarketingStageName
2) Field!MarketingComments

 1) Field!MarketingStageName  with value like this: 

01 Puchased Property
02 Fell out of Contract  
03 Winning Offer
04 In Contract/Escrow
05 Submitted Offer
06 Pennding Offer
07 Tour Property
and so..on

Please advice.

Thanks,

---

MN

Answer 1

 You might have a frame your expression like this :

=iif((Field!MarketingStageName.Value <5),Field!MarketingComments.Value,Nothing)

Pls remember this is only a suggestion

Anand

Answer 2

This field is not number, it is string that has numbers in it.

---

MN

Answer 3

To pull off the first 2 digits (01, 02, etc.) and do a comparison, try something like this this:

=IIF(CInt(LEFT(Fields!MarketingStageName.Value,2))<5,Fields!MarketingComments.Value,nothing)

Answer 4

Thank you Aaron,  I also did something like this and it worked:

=iif(val(Fields!cb_marketingstagename.Value)< 5, Fields!cb_marketingcomments.Value,

"")

---

MN