Skip to main content

DBO function to return 2 letter code for country and state/province from country name and state/province name

DBO.EQ_STD_STATE_PROVINCE_CODE_FROM_NAME(Parameter1, Parameter2) This function expects the country name and state/province name as inputs and will return the Code as listed on the Configuration tab, C

Updated over 2 weeks ago

DBO.EQ_STD_STATE_PROVINCE_CODE_FROM_NAME(Parameter1, Parameter2)

This function expects the country name and state/province name as inputs and will return the Code as listed on the Configuration tab, Countries screen.

Parameter(s)

Parameter1: Any field in the system where the country name is stored e.g. [Assignment: To Country]

Parameter2: Any field where the state/province name is stored e.g. [Assignment: To State/Province]

Example(s)

Example 1: Return the Code as listed on the Configurations tab, Countries screen.

  • DBO.EQ_STD_STATE_PROVINCE_CODE_FROM_NAME([Assignment: To Country],[Assignment: To State/Province])

State.png

Did this answer your question?