Please report to the 2 nd Floor of Waters Court. Hints and Tips No.16. Searching for a string of characters - the InStr function. You can use the InStr function to search for a sub-string within a larger string. In this case start at the first character in the string.
String is either a string or the field containing the string to be searched.
Substring is the string to search for, in double quotes. Where it finds an occurrence of the substring it will return a value equal to its start position in the string. We have said select all records where this return value is greater than 0, i.e. where it finds an occurrence. Browse Viewpoints 15 or Return to the GIS menu . Produced by SBSC for Coventry City Council on 27th August 1999.