add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
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