SELECT AuthorID, Surname, FirstName, '' AS akaSurname, '' AS akaFirstname, Surname AS Seq1, FirstName AS Seq2 FROM Author WHERE Surname Like #PreserveSingleQuotes(WildSearchText)# UNION SELECT Author.AuthorID, Surname, FirstName, akaSurname, akaFirstname, akaSurname as Seq1, akaFirstname as Seq2 FROM Author, aka WHERE Author.AuthorID = aka.AuthorID AND akaSurname Like #PreserveSingleQuotes(WildSearchText)# ORDER BY Seq1, Seq2 Corvey CW3 | Author Index

Author Index – authors’ names starting with &##0145;#URL.InitialLetter#&##0146;:

#IIf(akaFirstname is not '', DE(akaSurname & ', ' & akaFirstname), DE(akaSurname))# #IIf(akaSurname is not '', DE('>'), DE(''))# #Surname##IIf(FirstName is not '', DE(','), DE(''))# #FirstName#
 #IIf(akaFirstname is not '', DE(akaSurname & ', ' & akaFirstname), DE(akaSurname))# #IIf(akaSurname is not '', DE('>'), DE(''))# #Surname##IIf(FirstName is not '', DE(','), DE(''))# #FirstName#
 #IIf(akaFirstname is not '', DE(akaSurname & ', ' & akaFirstname), DE(akaSurname))# #IIf(akaSurname is not '', DE('>'), DE(''))# #Surname##IIf(FirstName is not '', DE(','), DE(''))# #FirstName#

Click on an author's name to see the Author Page for that author.