none
patindex using in substring

    Question

  • when

     

    PATINDEX('%HP D%',Substring(e.ErrorString,Charindex('RN',e.ErrorString,1)+ 3,Charindex('|',e.ErrorString,(Charindex('RN',e.ErrorString,1)))-Charindex('RN',e.ErrorString,1)-3))>0

    is it possiblo to check pattern index in a substring?

    Monday, September 27, 2010 6:10 AM

Answers

  • Yah u can do that.......

    Functions will check whether the argument is exactly passed or not... but they wont check from where they came... So, Its absolutely fine......

     

    If u need help, let us know what u r trying??

    Monday, September 27, 2010 6:13 AM