Sorting compound names

[Francois Van Lerberghe]

le 19/09/04 15:40, jda <jda at his.com> a écrit :

> Imagine a database containing books, each book
> having from 1 to n authors. If > 1 author, the
> names in the authors field are separated by CRs.
> We want to sort the records by the authors field.

I understand better.
I don't think it's possible unless you use a second table in witch you store
the authors, one per record, because I believe that the Replace function
replace only the first occurrence.

François Van Lerberghe
Rue Thier Monty, 15 A
4570 Marchin
Belgique