Occurs

Returns the number of times a character expression occurs within another character expression.cSearchExpression -- Specifies a character expression that OCCURS( ) searches for within cExpressionSearched. cExpressionSearched -- Specifies the character expression OCCURS( ) searches for cSearchExpression.OCCURS( ) returns 0 (zero) if cSearchExpression isn't found within cExpressionSearched.

2003-12-03

74 reads

OccursAny

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.Example:OccursAny('the,dog','The quick brown fox […]

2003-12-03

51 reads

Blogs

Do you have rarely used indexes that are hurting performance of writes?

By

We know that indexes are necessary for query performance but comes with overhead during...

Working with SQLSaturday SpeedPASSes – revamped!

By

In the Richmond, VA area, I am the organizer for our SQL Saturdays. Among...

Happy Hour at SQL in the City Austin

By

Tomorrow is SQL in the City 2019 – Austin. If you’ve registered, you’re going...

Read the latest Blogs

Forums

The Change Failure Rate

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Change Failure Rate

Table type

By Admingod

I just want to validate my use of a custom type. I'm doing a...

How to save collapse sections of the query window and save it like that

By itmasterw 60042

Hi, My manager would like it that when he collapses certain parts of the...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers