Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Find a String in a String

    You can also just do:

    substring(customernotes,

    charindex('PO:',customernotes + 'PO:')+3,

    charindex(' ',customernotes + ' PO: ',charindex('PO:',customernotes + ' PO:') )-charindex('PO:',customernotes)-3)

    This works where no PO is present also.

    Or to also handle the case...

Viewing post 1 (of 1 total)