select * from tbl_CHO_Operators where nullif( cho_zipcode, '' ) is not null and len( cho_zipcode ) > 5 and cho_countryId <> 5 update tbl_CHO_Operators set cho_zipcode = where cho_id = select * from tbl_CHO_Operators where nullif( cho_city, '' ) is null or nullif( cho_state, '' ) is null or nullif( cho_zipcode, '' ) is null and cho_countryId <> 5 select zipcity from tbl_UT_Zipcodes where zipstate = and zipcode = update tbl_CHO_Operators set cho_city = where cho_id = select zipstate from tbl_UT_Zipcodes where zipcity = and zipcode = update tbl_CHO_Operators set cho_state = where cho_id = select zipcity, zipstate from tbl_UT_Zipcodes where zipcode = update tbl_CHO_Operators set cho_city = , cho_state = where cho_id = Records with no city, state and zipcode values or
Records with no city and zipcodes values or
Records with no state and zipcodes values or
Records with city and state values but no zipcode value: #arrayLen( _arrayA )# records

Records with no city value only: #arrayLen( _arrayB )# records

Records with no state value only: #arrayLen( _arrayC )# records

Records with no city and state values only: #arrayLen( _arrayD )# records

Records with less or more than 5 digits of zipcode: #arrayLen( _arrayE )# records