Link to home
Create AccountLog 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
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of lulu50

ASKER

Thank you