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

75 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

52 reads

Blogs

Goal Progress–November 2020

By

This is my report, which continues on from the Oct report. It’s getting near...

Azure Synapse Analytics is GA!

By

(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...

5 Things You Should Know About Azure SQL

By

Azure SQL offers up a world of benefits that can be captured by consumers...

Read the latest Blogs

Forums

Database, RAM and processor Information

By sizal0234

Hi, I need to find the size of all db's and server's processor and...

reference for writing stored procedures (especially spatial) in DB2

By pietlinden

I can write stored procedures in SQL Server ... is there a guide somewhere...

A Technology Collapse

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Technology Collapse

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers