INVSS

Create queries to search courses for specific characters in specific locations.

Reporting Area(s):

Courses, Registrations

Required Parameters:

1. Course # (i.e. cocrse, rgcrse, pycrse)
2. Numeric selection value: position in Course # where character matching begins (i.e. 4-to start matching at the 4th character)
3. Character selection value: characters in Course # to match (i.e. "MGT", "101")

Optional Parameters:

None

Example(s):

~INVSS(cocrse,4,"MGT")~ returns course numbers containing MGT as the 4th, 5th and 6th characters of the course number

Notes:

You must enter a tilde ( ~ ) on both sides of the function.