this is a SQL issue.

DO NOT USE: CHARINDEX command

I have a table that looks like like table-1

below. I want a querry that can turn it into

table-2. Please dont give me a querry where

I have to use specifc names. my actual table

is far too large and has too many diffrernt

names for me to use a query like that. all

units in the column in my actual table have

commas as well.

Table-1 \begin{tabular}{|l|} \hline NAME \\ \hline Biden, Joe \\ \hline Trump, Donald \\ \hline Obama, Barack \\ \hline Bush, George \\ \hline \end{tabular} Table-2 \begin{tabular}{|l|} \hline NAME \\ \hline JOE BIDEN \\ \hline DONALD TRUMP \\ \hline BARACK OBAMA \\ \hline GEORGE BUSH \\ \hline \end{tabular}