myjobsinus (6/26/2015)
Thanks i created a function to split the string and that worked.
Don't write your own, odds are it's using one of the more inefficient methods. Use the one I recommended and Lynn attached.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability