select * from tbl_CHO_Operators
where cho_address like ' '

update tbl_CHO_Operators
set cho_address = null
where cho_address like ' '

---------------------------------------------

select * from tbl_CHO_Operators
where cho_address2 = ' '

update tbl_CHO_Operators
set cho_address2 = null
where cho_address2 = ' '

---------------------------------------------

select * from tbl_CHO_Operators
where cho_city = ' '

update tbl_CHO_Operators
set cho_city = null
where cho_city = ' '

---------------------------------------------

select * from tbl_CHO_Operators
where cho_state = ' '

update tbl_CHO_Operators
set cho_state = null
where cho_state = ' '

---------------------------------------------

select * from tbl_CHO_Operators
where cho_zipcode = ' '

update tbl_CHO_Operators
set cho_zipcode = null
where cho_zipcode = ' '

---------------------------------------------

select * from tbl_CHO_Operators
where cho_name like ' %'

update tbl_CHO_Operators
set cho_name = ltrim( cho_name )
where cho_name like ' %'

---------------------------------------------

select * from tbl_CHO_Operators
where cho_address like ' %'

update tbl_CHO_Operators
set cho_address = ltrim( cho_address )
where cho_address like ' %'

---------------------------------------------

select * from tbl_CHO_Operators
where cho_city like ' %'

update tbl_CHO_Operators
set cho_city = ltrim( cho_city )
where cho_city like ' %'

---------------------------------------------

select * from tbl_CHO_Operators
where cho_zipcode like ' %'

update tbl_CHO_Operators
set cho_zipcode = ltrim( cho_zipcode )
where cho_zipcode like ' %'