Scalar function 'f_contains' counts the number of times the first argument occurs within the second argument.
Given: @arg1, @arg2 (both VARCHAR), @cnt INT
SELECT @cnt = dbo.f_contains (@f_search_for = @arg1
, @f_container = @arg2)
Methods for Parsing XML files
Jon shows you several ways you can parse XML.
2007-10-02 (first published: 2002-06-20)