Home Forums SQL Server 2005 T-SQL (SS2K5) Need Charindex to Pick Up the Second Instance RE: Need Charindex to Pick Up the Second Instance

  • October 31, 2011 at 1:08 pm

    #1401263

    Add a NULLIF(patindex, 0).

    NULL -1 => NULL

    LEFT ('string', NULL) doesn't die on you.