locked
strip out last part of an Order Number RRS feed

  • Question

  • User-1210839387 posted

    using report builder 2.0

    I am trying how to figure out how to do this both in an expression and the SQL

    I have an order Number that will be like this:

    <SampleOrderNum>

    000111-1-10

    OR

    000112-1-4

    </SampleOrderNum>

    I want to trim out the last number (in my example it would be the "10" and the "9" respectively)

    how to do this in both sql sserver and SSRS expression

    thanks

    MC

    Tuesday, July 19, 2011 11:45 AM