Comparing Values (SCV) – Outline

Detailed Course Outline

Module 1 - Using eval to Compare

  • Understand the eval command
  • Explain evaluation functions
  • Identify and use comparison and conditional functions
  • Use the fieldformat command to format field values

Module 2 - Filtering with where

  • Use the where command to filter results
  • Use wildcards with the where command
  • Filter fields with the information functions, isnull and isnotnull