2 Replies Latest reply on Apr 14, 2009 1:45 PM by comment_1

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

    RedRanger

      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)