INVSS
Create queries to search course code for specific characters in specific locations.
Reporting Area(s)
Courses, Registrations
Required Parameters
- Course # (i.e. cocrse, rgcrse, pycrse)
- Numeric selection value: position in Course # where character matching begins (i.e. 4-to start matching at the 4th character)
- 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.