SQL iQuery Script Built-in Functions

Find First Not Of a List of Characters

FindFirstNotOf, firstNotOf

The findFirstNotOf() built-in functions returns the position of the first character in the session variable that is not one of the characters among the first parameter.


The findFirstNotOf built-in function scans the 2nd parameter for the first character not among the characters specified on the first parameter, beginning at the optional starting position.


  1. Variable or quoted character string that is the list of characters.
  2. The Session Variable that is searched.
  3. The starting position within the Session Variable (2nd parameter) to begin the scan.
eval &numbers = ' 0123456789';
eval &Address = '123 S. Main St.';
eval &pos = findFirstNotOf(&numbers, &Address);
if (&POS > 0);
eval &Street = sst(&Address,&pos);
#msg The Address is located on &Street

The output written to the joblog is:

The Addres is located on S. Main St.

If the 2nd parameter is made up entirely of characters from parameter 1, the result is 0.