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

76 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

54 reads

Blogs

Logging Messages with Raiserror – #SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 8 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Webinar – Building a Proper SQL Server Database Security Model

By

Tomorrow, March 9, 2020, at 3 PM EST, I will be giving a presentation...

Read the latest Blogs

Forums

How to get PartId from table #trades that have wrong Code ON Code Value To when

By ahmed_elbarbary.2010

How to get PartId from table #trades that have wrong Code ON Code Value...

Calling a Function to Update Temp Table

By rjjh78

Hello, I have created a function that will determine the Distance between 2 sets...

Alert configuration

By ramyours2003

How to set up alerts  on long running jobs on sql server ?,  pls...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers