select substring(yourcolumn,1,charindex(' ', yourcolumn))
+ substring(yourcolumn,charindex(' ', yourcolumn)+1,1)
from yourtable
group by substring(yourcolumn fname,1,charindex(' ', yourcolumn))
+ substring(fname,charindex(' ',yourcolumn fname)+1,1)
Ray Thompson
Tau Beta Pi ( <http://www.tbp.org/> www.tbp.org)
The Engineering Honor Society
865-546-4578
_____
From: Bradford T Comer [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 11, 2004 1:33 PM
To: SQL
Subject: MS SQL Quandary
Good Day
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]
