I have a table that holds author information; a request has come in to
create a Authors Index. Basically shrink down the number of pages printed
(hard copies) for the Authors Index. e.g there are 3 different papers;
(paperA, paperB & paperC).
Paper A was written by Hardy, John
Paper B was written by Hardy, J.
Paper C was written by Hardy, Jacob
I have a db field for each name, I must some how minimize the list, where as
for the example 3 mentioned they would come out to be 1 record, simply Hardy
J. (J. because it is the most generic) and only 1 record, therefore
minimizing the results/monies required to print huge Authors Indexes.
Any idea where to start? I really would prefer to do it within SQL if at all
possible.
Thanks In Advance.
Brad
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
