kast218 (11/17/2016)

I modify it to work on Case Sensitive Instance (be careful with variable names - use equal cases, in your function I have...

Good Point (the Data Type...)

Same Function - compatible with 2008:

CREATE FUNCTION dbo.udf_WordCount_2008

(

--declare

@STR VARCHAR(8000)

...

Thanks for the article!

If I may add another solution for splitting a list of values into a table

here is a short function that does the trick:

CREATE FUNCTION FN_LIST_TO_TABLE (@List varchar(max)...