Split pipe-delimited string into separate values
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.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread