Hello, everyone.

Is there an SQL equivalent to ColdFusions 'getToken' function?

Example:
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.

Thanks,