sgmunson (7/11/2014)
Thanks for the update. I was truly scratching my head on this until you explained what you did with it.
You are welcome! Steve
Just found out that I made a mistake typing the code too, 1 should be replaced with Charindex('/', reverse(t.col))
Thanks!