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>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help!!
- Thread starter 4040er
- Start date
Similar threads
- Locked
- Question