Is there an SQL equivalent to ColdFusions 'getToken' function?
Let's say string 'abc' is set to "Value A|Value B".
getToken(abc,1,'|') = "Value A", and getToken(abc,2,'|') = "Value B".
Is there a built in function for something similar in tSQL? Trying to get something like this to work in a Stored Procedure.