Returns the number of times any word in comma delimeted character expression occurs within another character expression.
cSearchExpression -- Specifies a comma delimeted character expression that OccursAny( ) searches for within cExpressionSearched.
cExpressionSearched -- Specifies the character expression OccursAny( ) searches for cSearchExpression.
OccursAny( ) returns 0 (zero) if cSearchExpression isn't found within cExpressionSearched.
OccursAny('the,dog','The quick brown fox jump over the lazy dogs....') --Returns 3(2 the and 1 dog)
Creating a PDF from a Stored Procedure in SQL Server
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.
2019-09-20 (first published: 2003-08-26)