By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
GetNamePart('Godfrey Roach', 'L') | GetNamePart('Godfrey Roach', 'F') | GetNamePart('Godfrey Roach', 'M') | GetNamePart('Godfrey Roach', 'LMF') |
---|---|---|---|
Roach | Godfrey | null | Roach Godfrey |
GetNamePart('Godfrey Michael Roach', 'L') | GetNamePart('Godfrey Michael Roach', 'F') | GetNamePart('Godfrey Michael Roach', 'M') | GetNamePart('Godfrey Michael Roach', 'LMF') |
---|---|---|---|
Roach | Godfrey | Michael | Roach Michael Godfrey |
GetNamePart('Godfrey M. Roach', 'L') | GetNamePart('Godfrey M. Roach', 'F') | GetNamePart('Godfrey M. Roach', 'M') | GetNamePart('Godfrey M. Roach', 'LMF') |
---|---|---|---|
Roach | Godfrey | M. | Roach M. Godfrey |
GetNamePart('Godfrey', 'L') | GetNamePart('Godfrey', 'F') | GetNamePart('Godfrey', 'M') | GetNamePart('Godfrey', 'LMF') |
---|---|---|---|
null | null | null | null |
GetNamePart(' Godfrey ', 'L') | GetNamePart(' Godfrey ', 'F') | GetNamePart(' Godfrey ', 'M') | GetNamePart(' Godfrey ', 'LMF') |
---|---|---|---|
null | null | null | null |
GetNamePart(' Godfrey Roach ', 'L') | GetNamePart(' Godfrey Roach ', 'F') | GetNamePart(' Godfrey Roach ', 'M') | GetNamePart(' Godfrey Roach ', 'LMF') |
---|---|---|---|
Roach | Godfrey | null | Roach Godfrey |
GetNamePart('Godfrey M. Roach', 'L') | GetNamePart('Godfrey M. Roach', 'F') | GetNamePart('Godfrey M. Roach', 'M') | GetNamePart('Godfrey M. Roach', 'LMF') |
---|---|---|---|
Roach | Godfrey | M. | Roach M. Godfrey |
GetNamePart('Godfrey Michael Roach', 'X') | GetNamePart('Godfrey Michael Roach', 'Y') | GetNamePart('Godfrey Michael Roach', 'Z') | GetNamePart('Godfrey Michael Roach', 'XYZ') |
---|---|---|---|
null | null | null | null |
GetNamePart('Godfrey Michael Roach', '') | GetNamePart('Godfrey Michael Roach', '') | GetNamePart('Godfrey Michael Roach', '') | GetNamePart('Godfrey Michael Roach', '') |
---|---|---|---|
null | null | null | null |