In the checkout sequence the address is given which includes the two digit state designation.
ie. in confirm.php
12 Tudor Road
Weston-s-Mare, ON BS22 7UQ
I do not need the "ON" I need the full name
where is this picked up from in the select statement