AnsweredAssumed Answered

Issue with case statement? How can I enter a range?

Question asked by RedRanger on Apr 14, 2009
Latest reply on Apr 14, 2009 by comment_1

Title

Issue with case statement? How can I enter a range?

Post

It will not accept the following case statement. It does not like the ... so how can I enter a range?

Case ( Position# = 901001...901999; "District 1 Eureka";
Position# = 902001...902999; "District 2 Redding";
Position# = 903001...903999; "District 3 Marysville";
Position# = 904001...904999; "District 4 Oakland";
Position# = 905001...905999; "District 5 San Luis Obispo";
Position# = 906001...906999; "District 6 Fresno";
Position# = 907001...907999; "District 7 Los Angeles";
Position# = 908001...908999; "District 8 San Bernardino";
Position# = 909001...909999; "District 9 Bishop";
Position# = 910001...910999; "District 10 Stockton";
Position# = 911001...911999; "District 11 San Diego";
Position# = 912001...912999; "District 12 Irvine";
Position# = 701001...701999; "Legal Division";
Position# = 702001...702999; "Administration";
Position# = 900000...900200; "Information Technology";
Position# = 932001...932999; "Division of Equipment";
Position# = 559001...559999; "Engineering Services ";
Position# = 913140; "Division of Environmental Analysis";
Position# = 913176; "Division of Project Management";
Position# = 913016; "Division of Project Management";
Position# = 913601; "Division of Pavement";
Position# = 311001; "Intercity High Speed Rail";
Position# = 913110; "Division of Local Assistance";
Position# = 913398...913399; "Division of Traffic Operations";
Position# = 913350; "Division of Traffice Operations";
Position# = 913176; "Division of Project Management";
Position# = 913400; "Division of Right of Way";
Position# = 913176; "Division of Project Management";
Position# = 913330; "Division of Design";
Position# = 913200; "Division of Design";
Position# = 913019; "Division of Design";
Position# = 913250; "Division of Design";
Position# = 913500; "Division of Construction";
Position# = 913600...913710; "Division of Maintenance";
Position# = 900063; "Division of Aeronautics";
Position# = 900064; "Division of Mass Transportation";
Position# = 913999; "Division of Innovation and Research";
Position# = 913155; "Division of Innovation and Research";
Position# = 913189...913193; "Division of Innovation and Research";
Position# = 913338...913339; "Division of Innovation and Research";
Position# = 900485; "Division of Transportation System Info";
Position# = 900074; "Division of Transportation";
Position# = 900075; "Division of Rail";
Position# = 900077; "Division of Audits and Investigations";
Position# = 913176; "Division of Project Management";
Position# = 900079; "Dept Admin Directors Office";
Position# = 900080; "Division of Transportation Programming";
Position# = 900281; "Division of Accounting";
Position# = 900481; "Division of Accounting";
Position# = 900381; "Division of Accounting";
Position# = 900081; "Division of Accounting";
Position# = 900581; "Division of Accounting";
Position# = 900004; "Division of Accounting";
Position# = 900082; "Division of Budgets";
Position# = 900084; "External Offices";
Position# = 900585; "Departmental Administration";
Position# = 900085; "Departmental Administraton";
Position# = 913088; "Civil Rights";
Position# = 694008; "Office of Traffic Safety";
Position# = 694005; "Office of Traffic Safety";
Position# = 900092; "Financial Management System";
Position# = 900100; "Gov Transportation Initiative";
Position# = 900095; "Department Administration"; Other)
































Outcomes