Operation Details
Description: This method is used for searching SchoolDistricts. Search is performed based on partial match of the name criteria.
Sterotype: nsmulti
SQL 
SELECT
  SchoolDistrict.schoolDistrictID,
  SchoolDistrict.name,
  SchoolDistrict.county,
  SchoolDistrict.state
INTO
  :schoolDistrictID,
  :name,
  :county,
  :state 
FROM
  SchoolDistrict 
WHERE 
  (
    :searchByName = '0' 
    OR SchoolDistrict.upperName like :name 
  ) 
  AND 
  (
    :searchByCounty = '0' 
    OR SchoolDistrict.county = :county 
  ) 
  AND 
  (
    :searchByState = '0' 
    OR SchoolDistrict.state = :state 
  )