|
|
|
Occurs(String1: String In String2: String): Number
Returns the number of occurrences of String1 in String 2. If there are no occurrences, 0 will be returned.
Occurs can only be used with string or memo fields or constants.
Occurs function syntax has these named arguments:
Parameter |
Description |
String1 |
Required. String to search String2 for. |
String2 |
Required. The field reference or string to be searched for occurrences of String1. |
For example:
SELECT * FROM Country WHERE OCCURS('NEW' IN Name) > 0
|
|
|
