Yet another split function.....
While I do appreciate the effort, there are millions of these with extensive research on performance comparisons between the various options. This horse has been flogged to death.
EmbeddedSplit8K returns only chars delimited by two delimiter e.g. from the string 'Phone (123-45676) - Florida','(',')' returns only 123-45676
Guess I didn't read it thoroughly enough. That's an interesting requirement though, surely that belongs in the presentation layer, although I suppose it may function in an ETL process. Why don't you write a little on how you are using this, it does sound interesting.
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]