Administrative Information Services

Data Administration

VISION:Results Workshop #2 Outline

RECORD SELECTION IN VISION:Results

I. Selection Commands

A. IF/ELSE/ENDIF Command

1. Logic Flow
2. Syntax
3. Nested IF's

B. CASE/WHEN/ENDCASE command

1. Logic Flow
2. Syntax

II. Selection Logic

A. Relational Operators
B. Logical Connectors
C. Comparisons

1. Variables

a. Field Types
b. Field Sizes

2. Literals
3. Range or Series

III. Workshop Exercise


Michigan State University Copyright 1998.  All rights reserved.    This page last updated on 06/02/02 10:55 PM.

  If you have comments or suggestions about this webpage Email us.    (Please do not change the subject line)