|
|
|
Position(String1: String In String2: String): Number
Returns the position of the start of the first instance of String2 contained within String1. If String2 is not found in String1 or String1 is zero length, 0 is returned. If either argument is null, null is returned.
Position function syntax has these named arguments:
Parameter |
Description |
String 1 |
Required. String to be searched for String 2. |
String 2 |
Required. Field reference or String to search for in String 1. |
For example:
SELECT * FROM Country WHERE POSITION('NEW' IN Name) > 0
|
|
|
