coalesce (per.KNOWN_AS,per.FIRST_FORNAME) FNAME,
I was expecting the above to:
- Use the known_as name if there is a known as name
- Use the FIRST_FORNAME if there is no KNOWN_AS name
The known_as name is populated if its there, although the FORENAME isnt being populated if there is no KNOWNAS name, despite FORENAME being avaiable.
Why is this?