patindex using in substring


  • 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


  • 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