State Abbreviations

Hello,

I have created a new entity field to track customer brick and mortar state locations in addition to the billing and shipping addresses. Is there a clean way to convert the full state name into the abbreviations on a saved search?

Something like this?

CASE WHEN {custentity8} LIKE ‘%Alabama%’ THEN 'AL' WHEN {custentity8} LIKE ’%Alaska%’ THEN 'AK' WHEN {custentity8} LIKE ‘%Arizona%’ THEN 'AZ' WHEN {custentity8} LIKE ‘%Arkansas%’ THEN 'AR' WHEN {custentity8} LIKE ‘%California%’ THEN 'CA' WHEN {custentity8} LIKE ‘%Colorado%’ THEN 'CO' WHEN {custentity8} LIKE ‘%Connecticut%’ THEN 'CT' WHEN {custentity8} LIKE ‘%Delaware%’ THEN 'DE' WHEN {custentity8} LIKE ‘%District of Columbia%’ THEN 'DC' WHEN {custentity8} LIKE ‘%Florida%’ THEN 'FL' END