Link to home
Start Free TrialLog in
Avatar of lulu50
lulu50Flag for United States of America

asked on

remove abbreviation

Hi,

I have a field in the database that list the states like this.

StateName

Alaska (AK)
Arizona (AZ)
Arkansas (AR)
California (CA)
Colorado (CO)
Connecticut (CT)
Delaware (DE)
Florida (FL)
Georgia (GA)
Hawaii (HI)
Idaho (ID)
Illinois (IL)

what I want is to output the field like this

<cfoutput>#DispChDetail.StateName#</cfoutput>

the result should be without the abbreviation

like this

Alaska
Arizona
Arkansas
California
Colorado
Connecticut
Delaware
Florida
Georgia
Hawaii
Idaho
Illinois

I don't want to remove the abbreviation from the database because I need it to display it with abbreviation in a different place.

just on one page that I don't want the abbreviation.
How can I remove it.
 
ASKER CERTIFIED SOLUTION
Avatar of SidFishes
SidFishes
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of lulu50

ASKER

Thank you