Mike Hughes
Registered User.
- Local time
- Today, 19:32
- Joined
- Mar 23, 2002
- Messages
- 493
DB has a field for First Name, Middle Name and Last Name. I did this select statement to combine the three fields into one Full Name. The problem is that when there is no Middle Name I'm not getting anything....I want the first and last even when there is no middle....can someone show me how to change this ?
SELECT
NOLDBA_USER_ACCOUNTS.FIRST_NAME +' ' + NOLDBA_USER_ACCOUNTS.MIDDLE_INITIAL + ' ' + NOLDBA_USER_ACCOUNTS.LAST_NAME AS [FULL NAME]
SELECT
NOLDBA_USER_ACCOUNTS.FIRST_NAME +' ' + NOLDBA_USER_ACCOUNTS.MIDDLE_INITIAL + ' ' + NOLDBA_USER_ACCOUNTS.LAST_NAME AS [FULL NAME]