Sorting last name field

[diggercwh]

I'm sorting records by last name and then first name and seem to be getting wierd results. When I sort last name of St. John it shows up in the J's. Likewise with all names with two names such as Von Kampen. How do I need to enter these last names to sort correctly? Thanks for any help.

[danjacoby]

Got a feeling you're either putting the separate words into separate fields, or putting the full name into one field and then sorting based on a calculated field using the "RightWords" calc.

Which is it?