storing names for sorting

[Joeri van Ruth <Joeri.van.Ruth@dds-projects.nl>]

When storing people in a database, one often wants to sort them by
their last name.  But sometimes, parts of the last name should be
ignored while sorting.  For example, my name is "Joeri van Ruth", and
my last name is "van Ruth", but my name should be listed under "R", not
under "v".  

Which attribute can best be used for storing the part of the last name
that is relevant for sorting?


Joeri