This is the SQL code for THIS ARTICLE SNIPPET #2 - UDF_ITEMEXTRACT - SQL FUNCTION TO EXTRACT AN ITEM OUT OF A DELIMITED LIST -- ============================================= -- Author: John Nelson (Number2) -- Create date: 2007-05-26 -- Description: Given a delimited list, a position and a delimiter...
Posted to
Number2 Blog - MyITForum.com
(Weblog)
by
jnelson
on
11-13-2007
Filed under: SQL, SMS, SMS 2003, outlook, udf_ItemExtract, v_ProductFileInfo, INT, BIGINT, CAST, itemExtract, order by, sql 2005, v_GS_SoftwareFile, SUBSTRING, CHARINDEX, sorting, v_GS_SoftwareProduct