Richiep86
asked on
coalesce (per.KNOWN_AS,per.FIRST_FORNAME) FNAME,
Hi guys,
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
However.
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?
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
However.
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It had white spaces in the surname.
Thanks alot!
Thanks alot!
COALESCE works with NULLs, if the value of KNOWN_AS is not NULL (if it contains spaces), then it will be used.