lulu50
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.St ateName#</ 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.
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.St
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER