Customer search that returns full state names for bill and ship address

Customer search that returns full state names for billing and shipping address.

1. Navigate to Lists > Search > Saved Searches > New
2. Select Customer as Search Type
3. Enter value for Search Title
4. Under Criteria tab > Standard sub tab > Add "Default Billing Address = No"
5. Under Results tab > Columns sub tab > Add the following formula:

*Formula (Text) | Formula = DECODE((CASE WHEN {shipstate} IS NOT NULL THEN {shipstate} ELSE {billstate} END),'AL', 'Alabama', 'AK', 'Alaska', 'AZ', 'Arizona', 'AR', 'Arkansas', 'CA', 'California', 'CO', 'Colorado', 'CT', 'Connecticut', 'DE', 'Delaware', 'DC', 'District of Columbia', 'FL', 'Florida', 'GA', 'Georgia', 'HI', 'Hawaii', 'ID', 'Idaho', 'IL', 'Illinois', 'IN', 'Indiana', 'IA', 'Iowa', 'KS', 'Kansas', 'KY', 'Kentucky', 'LA', 'Louisiana', 'ME', 'Maine', 'MD', 'Maryland', 'MA', 'Massachusetts', 'MI', 'Michigan', 'MN', 'Minnesota', 'MS', 'Mississippi', 'MO', 'Missouri', 'MT', 'Montana', 'NE', 'Nebraska', 'NV', 'Nevada', 'NH', 'New Hampshire', 'NJ', 'New Jersey', 'NM', 'New Mexico', 'NY', 'New York', 'NC', 'North Carolina', 'ND', 'North Dakota', 'OH', 'Ohio', 'OK', 'Oklahoma', 'OR', 'Oregon', 'PA', 'Pennsylvania', 'RI', 'Rhode Island', 'SC', 'South Carolina', 'SD', 'South Dakota', 'TN', 'Tennessee', 'TX', 'Texas', 'UT', 'Utah', 'VT', 'Vermont', 'VI', 'Virgin Island', 'VA', 'Virginia', 'WA', 'Washington', 'WV', 'West Virginia', 'WI', 'Wisconsin', 'WY', 'Wyoming','AB', 'Alberta','BC', 'British Columbia','MB', 'Manitoba','NB', 'New Brunswick','NL', 'Newfoundland','NT', 'Northwest Territories','NS', 'Nova Scotia','NU', 'Nunavut','ON', 'Ontario','PE', 'Prince Edward Island','QC', 'Quebec','SK', 'Saskatchewan','YT', 'Yukon')

*Add any other Customer fields you would like to see on the results.

6. Click Save and Run