\documentclass{article}

\usepackage{datatool}

\begin{filecontents*}{test.csv}
FirstName,Surname,Score
John,"Smith, Jr",68
Jane,Brown,75
Andy,Brown,42
Z\"oe,Adams,52
Roger,Brady,58
Clare,Verdon,45
Henk,van der Mere,71
Jos,de la Mere,58
Mary,Dane,65
Paul,Dobson,62
\end{filecontents*}

\DTLloaddb{scores}{test.csv}

\begin{document}

\begin{table}[htbp]
\caption{Student scores (case sensitive sort)}
\centering
\DTLsort{Surname,FirstName}{scores}%
\begin{tabular}{llr}
\bfseries Surname &
\bfseries First Name &
\bfseries Score (\%)%
\DTLforeach{scores}%
 {\firstname=FirstName,\surname=Surname,\score=Score}%
 {\\\surname & \firstname & \score}
\end{tabular}
\end{table}

\begin{table}[htbp]
\caption{Student scores (case ignored when sorting)}
\centering
\DTLsort*{Surname,FirstName}{scores}%
\begin{tabular}{llr}
\bfseries Surname &
\bfseries First Name &
\bfseries Score (\%)\relax
\DTLforeach{scores}%
 {\firstname=FirstName,\surname=Surname,\score=Score}%
 {\\\surname & \firstname & \score}
\end{tabular}
\end{table}

\end{document}
