I have a field named PROJECT_DESCRIPTION that concatenates the STREET_NAME, FROM and TO fields. Sometimes the FROM or TO fields are only address ranges. In my PROJECT_DESCRIPTION field I would like to insert the STREET_NAME only if the FROM or TO values are numbers. For example, STREET_NAME = BURLEY CV, FROM = 3201, AND TO = BURLEY BND. PROJECT_DESCRIPTION = BURLEY CV from 3201 to BURLEY BND. I would like PROJECT_DESCRIPTION to equal BURLEY CV from 3201 BURLEY CV to BURLEY BND. The problem is that there is not always an address number, and in those cases I want to leave the PROJECT_DESCRIPTION value as is.
أكثر...
أكثر...