SUBSTRINGOF()

From Recital Documentation Wiki
Jump to: navigation, search

Purpose

Function to perform a case-sensitive search of a string to determine if it contains a specified character string


Syntax

SUBSTRINGOF(<expC1>,<expC2>)


See Also

BETWEEN(), CHROVERLAP(), CONTAINS(), EMPTY(), ENDSWITH(), EVALUATE(), EXPRCHECK(), FOR(), INDEX, INDEXOF(), INLIST(), INRANGE(), ISALPHA(), ISBLANK(), ISDIGIT(), LOWER(), MAX(), MAXVALUES(), MIN(), MINVALUES(), MTOS(), PROPER(), Relational Operators, SEEK, SEEK(), SET EXACT, STARTSWITH(), TYPE(), UPPER(), VARTYPE()


Description

The SUBSTRINGOF() function returns .T. (True) if the character string <expC1> contains the specified character string, <expC2>.

A case-sensitive search is performed.


Parameters Description
<expC1> The character string to be searched.
<expC2> The character string to search for.


Example

open database southwind
use orders
browse for substringof(customerid,"AT")


Products

Recital Server, Recital