using this syntax how can I modify it to also give me middle initials.<br>Elsie H Reed<br><br>select firstname = substring(mycolumn , 1, charindex(' ',yourcolumn) -1 ), <br>lastname = ltrim(substring(mycolumn,charindex(' ',mycolumn) + 1, len(mycolumn)- len(substring(mycolumn, 1, charindex(' ',mycolumn) -1 ))))<br>from mytable<br>